Jun 27 2019 01:16 PM
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.
Jun 27 2019 01:51 PM
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
if that's what you are looking for.