SOLVED

Help with Bar graph formatting!?

Copper Contributor

Hello, 

I'm looking to create a bar graph that has three bars (total visited, added, and conversion rate) grouped by regions (Nationwide, CA, WA, and other). You can see in my attachment how it looks; however, for some reason other is not lining up and I cannot figure out why. I feel like it it is an easy fix and I am blanking right now. Can someone help me?

9 Replies
What is the chart supposed to look like? Non-overlapping bars? If so, you can just change the chart type.

@Jan Karel Pieterse 

This is what I'm trying to do, but 'Other' is underneath the bars?

Not sure. Your sample file contains a link to another file, which is caused by the chart not pointing to the correct data.

@Jan Karel Pieterse 

 

Try this one

I'm sorry, but please upload a file containing the chart including the source data of that chart. Please note that this is volunteer work, not a paid job :)

@Jan Karel Pieterse  I really appreciate it! 

 

best response confirmed by bangerz253 (Copper Contributor)
Solution

The chart's source data needed editing, for some x-es a the value in column C was omitted.

Old SERIES formulas:

=SERIES("Conversion Rate",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31,'OM - QualTek '!$B$38),('OM - QualTek '!$J$23:$K$23,'OM - QualTek '!$J$30:$K$30,'OM - QualTek '!$J$37:$K$37,'OM - QualTek '!$J$44:$K$44),3)
=SERIES("Added ACU",('OM - Network'!$B$17:$C$17,'OM - Network'!$B$24:$C$24,'OM - Network'!$B$31,'OM - Network'!$B$38),('OM - Network'!$J$19:$K$19,'OM - Network'!$J$26:$K$26,'OM - Network'!$J$33:$K$33,'OM - Network'!$J$40:$K$40),2)
=SERIES("Total Visited",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31,'OM - QualTek '!$B$38),('OM - QualTek '!$J$18:$K$18,'OM - QualTek '!$J$25:$K$25,'OM - QualTek '!$J$32:$K$32,'OM - QualTek '!$J$39:$K$39),1)

New SERIES formulas:

=SERIES("Conversion Rate",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31:$C$31,'OM - QualTek '!$B$38:$C$38),('OM - QualTek '!$J$23:$K$23,'OM - QualTek '!$J$30:$K$30,'OM - QualTek '!$J$37:$K$37,'OM - QualTek '!$J$44:$K$44),3)
=SERIES("Added ACUs",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31:$C$31,'OM - QualTek '!$B$38:$C$38),('OM - QualTek '!$J$19:$K$19,'OM - QualTek '!$J$26:$K$26,'OM - QualTek '!$J$33:$K$33,'OM - QualTek '!$J$40:$K$40),2)
=SERIES("Total Visited",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31:$C$31,'OM - QualTek '!$B$38:$C$38),('OM - QualTek '!$J$18:$K$18,'OM - QualTek '!$J$25:$K$25,'OM - QualTek '!$J$32:$K$32,'OM - QualTek '!$J$39:$K$39),1)

@Jan Karel Pieterse Thanks so much! Save a lot of headaches :)

You're welcome!
1 best response

Accepted Solutions
best response confirmed by bangerz253 (Copper Contributor)
Solution

The chart's source data needed editing, for some x-es a the value in column C was omitted.

Old SERIES formulas:

=SERIES("Conversion Rate",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31,'OM - QualTek '!$B$38),('OM - QualTek '!$J$23:$K$23,'OM - QualTek '!$J$30:$K$30,'OM - QualTek '!$J$37:$K$37,'OM - QualTek '!$J$44:$K$44),3)
=SERIES("Added ACU",('OM - Network'!$B$17:$C$17,'OM - Network'!$B$24:$C$24,'OM - Network'!$B$31,'OM - Network'!$B$38),('OM - Network'!$J$19:$K$19,'OM - Network'!$J$26:$K$26,'OM - Network'!$J$33:$K$33,'OM - Network'!$J$40:$K$40),2)
=SERIES("Total Visited",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31,'OM - QualTek '!$B$38),('OM - QualTek '!$J$18:$K$18,'OM - QualTek '!$J$25:$K$25,'OM - QualTek '!$J$32:$K$32,'OM - QualTek '!$J$39:$K$39),1)

New SERIES formulas:

=SERIES("Conversion Rate",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31:$C$31,'OM - QualTek '!$B$38:$C$38),('OM - QualTek '!$J$23:$K$23,'OM - QualTek '!$J$30:$K$30,'OM - QualTek '!$J$37:$K$37,'OM - QualTek '!$J$44:$K$44),3)
=SERIES("Added ACUs",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31:$C$31,'OM - QualTek '!$B$38:$C$38),('OM - QualTek '!$J$19:$K$19,'OM - QualTek '!$J$26:$K$26,'OM - QualTek '!$J$33:$K$33,'OM - QualTek '!$J$40:$K$40),2)
=SERIES("Total Visited",('OM - QualTek '!$B$17:$C$17,'OM - QualTek '!$B$24:$C$24,'OM - QualTek '!$B$31:$C$31,'OM - QualTek '!$B$38:$C$38),('OM - QualTek '!$J$18:$K$18,'OM - QualTek '!$J$25:$K$25,'OM - QualTek '!$J$32:$K$32,'OM - QualTek '!$J$39:$K$39),1)

View solution in original post