SOLVED
Home

Help with Bar graph formatting!?

%3CLINGO-SUB%20id%3D%22lingo-sub-717187%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717187%22%20slang%3D%22en-US%22%3EWhat%20is%20the%20chart%20supposed%20to%20look%20like%3F%20Non-overlapping%20bars%3F%20If%20so%2C%20you%20can%20just%20change%20the%20chart%20type.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717125%22%20slang%3D%22en-US%22%3EHelp%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717125%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20to%20create%20a%20bar%20graph%20that%20has%20three%20bars%20(total%20visited%2C%20added%2C%20and%20conversion%20rate)%20grouped%20by%20regions%20(Nationwide%2C%20CA%2C%20WA%2C%20and%20other).%20You%20can%20see%20in%20my%20attachment%20how%20it%20looks%3B%20however%2C%20for%20some%20reason%20other%20is%20not%20lining%20up%20and%20I%20cannot%20figure%20out%20why.%20I%20feel%20like%20it%20it%20is%20an%20easy%20fix%20and%20I%20am%20blanking%20right%20now.%20Can%20someone%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-717125%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717210%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20I'm%20trying%20to%20do%2C%20but%20'Other'%20is%20underneath%20the%20bars%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717308%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717308%22%20slang%3D%22en-US%22%3ENot%20sure.%20Your%20sample%20file%20contains%20a%20link%20to%20another%20file%2C%20which%20is%20caused%20by%20the%20chart%20not%20pointing%20to%20the%20correct%20data.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717531%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717531%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20one%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719206%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719206%22%20slang%3D%22en-US%22%3EI'm%20sorry%2C%20but%20please%20upload%20a%20file%20containing%20the%20chart%20including%20the%20source%20data%20of%20that%20chart.%20Please%20note%20that%20this%20is%20volunteer%20work%2C%20not%20a%20paid%20job%20%3A-)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719211%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719211%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%20I%20really%20appreciate%20it!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719404%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719404%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20chart's%20source%20data%20needed%20editing%2C%20for%20some%20x-es%20a%20the%20value%20in%20column%20C%20was%20omitted.%3C%2FP%3E%0A%3CP%3EOld%20SERIES%20formulas%3A%3C%2FP%3E%0A%3CPRE%3E%3DSERIES(%22Conversion%20Rate%22%2C('OM%20-%20QualTek%20'!%24B%2417%3A%24C%2417%2C'OM%20-%20QualTek%20'!%24B%2424%3A%24C%2424%2C'OM%20-%20QualTek%20'!%24B%2431%2C'OM%20-%20QualTek%20'!%24B%2438)%2C('OM%20-%20QualTek%20'!%24J%2423%3A%24K%2423%2C'OM%20-%20QualTek%20'!%24J%2430%3A%24K%2430%2C'OM%20-%20QualTek%20'!%24J%2437%3A%24K%2437%2C'OM%20-%20QualTek%20'!%24J%2444%3A%24K%2444)%2C3)%0A%3DSERIES(%22Added%20ACU%22%2C('OM%20-%20Network'!%24B%2417%3A%24C%2417%2C'OM%20-%20Network'!%24B%2424%3A%24C%2424%2C'OM%20-%20Network'!%24B%2431%2C'OM%20-%20Network'!%24B%2438)%2C('OM%20-%20Network'!%24J%2419%3A%24K%2419%2C'OM%20-%20Network'!%24J%2426%3A%24K%2426%2C'OM%20-%20Network'!%24J%2433%3A%24K%2433%2C'OM%20-%20Network'!%24J%2440%3A%24K%2440)%2C2)%0A%3DSERIES(%22Total%20Visited%22%2C('OM%20-%20QualTek%20'!%24B%2417%3A%24C%2417%2C'OM%20-%20QualTek%20'!%24B%2424%3A%24C%2424%2C'OM%20-%20QualTek%20'!%24B%2431%2C'OM%20-%20QualTek%20'!%24B%2438)%2C('OM%20-%20QualTek%20'!%24J%2418%3A%24K%2418%2C'OM%20-%20QualTek%20'!%24J%2425%3A%24K%2425%2C'OM%20-%20QualTek%20'!%24J%2432%3A%24K%2432%2C'OM%20-%20QualTek%20'!%24J%2439%3A%24K%2439)%2C1)%3C%2FPRE%3E%0A%3CP%3ENew%20SERIES%20formulas%3A%3C%2FP%3E%0A%3CPRE%3E%3DSERIES(%22Conversion%20Rate%22%2C('OM%20-%20QualTek%20'!%24B%2417%3A%24C%2417%2C'OM%20-%20QualTek%20'!%24B%2424%3A%24C%2424%2C'OM%20-%20QualTek%20'!%24B%2431%3A%24C%2431%2C'OM%20-%20QualTek%20'!%24B%2438%3A%24C%2438)%2C('OM%20-%20QualTek%20'!%24J%2423%3A%24K%2423%2C'OM%20-%20QualTek%20'!%24J%2430%3A%24K%2430%2C'OM%20-%20QualTek%20'!%24J%2437%3A%24K%2437%2C'OM%20-%20QualTek%20'!%24J%2444%3A%24K%2444)%2C3)%0A%3DSERIES(%22Added%20ACUs%22%2C('OM%20-%20QualTek%20'!%24B%2417%3A%24C%2417%2C'OM%20-%20QualTek%20'!%24B%2424%3A%24C%2424%2C'OM%20-%20QualTek%20'!%24B%2431%3A%24C%2431%2C'OM%20-%20QualTek%20'!%24B%2438%3A%24C%2438)%2C('OM%20-%20QualTek%20'!%24J%2419%3A%24K%2419%2C'OM%20-%20QualTek%20'!%24J%2426%3A%24K%2426%2C'OM%20-%20QualTek%20'!%24J%2433%3A%24K%2433%2C'OM%20-%20QualTek%20'!%24J%2440%3A%24K%2440)%2C2)%0A%3DSERIES(%22Total%20Visited%22%2C('OM%20-%20QualTek%20'!%24B%2417%3A%24C%2417%2C'OM%20-%20QualTek%20'!%24B%2424%3A%24C%2424%2C'OM%20-%20QualTek%20'!%24B%2431%3A%24C%2431%2C'OM%20-%20QualTek%20'!%24B%2438%3A%24C%2438)%2C('OM%20-%20QualTek%20'!%24J%2418%3A%24K%2418%2C'OM%20-%20QualTek%20'!%24J%2425%3A%24K%2425%2C'OM%20-%20QualTek%20'!%24J%2432%3A%24K%2432%2C'OM%20-%20QualTek%20'!%24J%2439%3A%24K%2439)%2C1)%0A%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-720064%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThanks%20so%20much!%20Save%20a%20lot%20of%20headaches%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721130%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Bar%20graph%20formatting!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721130%22%20slang%3D%22en-US%22%3EYou're%20welcome!%3C%2FLINGO-BODY%3E
bangerz253
Occasional 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.
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! 

 

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!
Related Conversations