Home

Help with formatting Excel Graph?

%3CLINGO-SUB%20id%3D%22lingo-sub-726412%22%20slang%3D%22en-US%22%3EHelp%20with%20formatting%20Excel%20Graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-726412%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20to%20change%20my%20bar%20graph%20something%20similar%20to%20the%20picture%20I've%20attached.%20Right%20now%20I%20have%20bar%20graphs%20overlapping%20in%20each%20other%2C%20but%20looking%20to%20alter%20the%20look.%20The%20graph%20should%20have%20one%20bar%20for%20each%20region.%20Like%20the%20picture%2C%20I%20would%20have%20'Total%20visited'%20then%20'Added%20ACUs'%20on%20top%20of%20it.%20The%20line%20would%20be%20the%20conversion%20%25.%20Anyone%20able%20to%20help%20me%3F%20Been%20trying%20somethings%20out%2C%20but%20it's%20not%20working%20out%20the%20way%20I%20envisioned%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-726412%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-726597%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formatting%20Excel%20Graph%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-726597%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365347%22%20target%3D%22_blank%22%3E%40bangerz253%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20I'd%20remove%20merging%20of%20the%20cells%2C%20you%20don't%20need%20it.%20Merging%20is%20always%20source%20of%20errors%20and%20undesired%20behavior.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20with%20them%2C%20edit%20data%20for%20the%20axis%20and%20series%20keeping%20only%20one%20cell%2C%20not%20range%20of%20two%20for%20each%20of%20them.%20It%20will%20look%20like%3C%2FP%3E%0A%3CPRE%3E%3DSERIES(%22Added%20ACUs%22%2C('OM%20-%20QualTek%20'!%24B%2417%2C'OM%20-%20QualTek%20'!%24B%2424%2C'OM%20-%20QualTek%20'!%24B%2431%2C'OM%20-%20QualTek%20'!%24B%2438)%2C('OM%20-%20QualTek%20'!%24J%2419%2C'OM%20-%20QualTek%20'!%24J%2426%2C'OM%20-%20QualTek%20'!%24J%2433%2C'OM%20-%20QualTek%20'!%24J%2440)%2C2)%3C%2FPRE%3E%0A%3CP%3EWhen%20click%20on%20Change%20Chart%20Type%20for%20the%20chart%20and%20apply%20Stacked%20Columns%20for%20first%20two%20series%20and%20Line%20for%20the%20the%20last.%3C%2FP%3E%0A%3CP%3EIt'll%20be%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20489px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121521i35C5B5E54C74C43F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eif%20that's%20what%20you%20are%20looking%20for.%3C%2FP%3E%3C%2FLINGO-BODY%3E
bangerz253
Occasional Contributor

Hello,

 

I'm looking to change my bar graph something similar to the picture I've attached. Right now I have bar graphs overlapping in each other, but looking to alter the look. The graph should have one bar for each region. Like the picture, I would have 'Total visited' then 'Added ACUs' on top of it. The line would be the conversion %. Anyone able to help me? Been trying somethings out, but it's not working out the way I envisioned it. 

1 Reply

@bangerz253 

 

First I'd remove merging of the cells, you don't need it. Merging is always source of errors and undesired behavior.

 

If with them, edit data for the axis and series keeping only one cell, not range of two for each of them. It will look like

=SERIES("Added ACUs",('OM - QualTek '!$B$17,'OM - QualTek '!$B$24,'OM - QualTek '!$B$31,'OM - QualTek '!$B$38),('OM - QualTek '!$J$19,'OM - QualTek '!$J$26,'OM - QualTek '!$J$33,'OM - QualTek '!$J$40),2)

When click on Change Chart Type for the chart and apply Stacked Columns for first two series and Line for the the last.

It'll be like

image.png

if that's what you are looking for.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies