Forum Discussion
Solved
Help with Bar graph formatting!?
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 look...
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)
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 :-)
JKPieterse I really appreciate it!
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)JKPieterse Thanks so much! Save a lot of headaches :)