Jun 24 2019 06:49 AM - edited Jun 24 2019 07:30 AM
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?
Jun 24 2019 07:04 AM
Jun 24 2019 07:31 AM
This is what I'm trying to do, but 'Other' is underneath the bars?
Jun 24 2019 08:17 AM
Jun 24 2019 09:06 AM
Jun 25 2019 01:21 AM
Jun 25 2019 01:29 AM
@Jan Karel Pieterse I really appreciate it!
Jun 25 2019 04:11 AM
SolutionThe 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)
Jun 25 2019 12:53 PM
@Jan Karel Pieterse Thanks so much! Save a lot of headaches :)
Jun 25 2019 04:11 AM
SolutionThe 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)