Help with formatting Excel Graph?

Copper 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.