Forum Discussion

bangerz253's avatar
bangerz253
Copper Contributor
Jun 24, 2019
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...
BI & Data Analysis
Charting
excel
  • JKPieterse's avatar
    JKPieterse
    Jun 25, 2019

    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's avatar
JKPieterse
Silver Contributor
Jun 24, 2019
What is the chart supposed to look like? Non-overlapping bars? If so, you can just change the chart type.
  • bangerz253's avatar
    bangerz253
    Copper Contributor
    Jun 24, 2019

    JKPieterse 

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

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jun 24, 2019
      Not sure. Your sample file contains a link to another file, which is caused by the chart not pointing to the correct data.

Resources