Mixed Bar and Stacked Bar chart

[GarryWelborn]

Hi,

my apologies if this question has already been asked, but I've searched and cannot find one.

i would like to produce a graph from three columns of data, where the first column (target) produces a single bar and the next two columns (actual and forecast) are shown as a stacked bar.

Is anyone able to help?

Thank you

Garry

 

[mole999]

i can't visualise what you want with data, its possible to mix the charts, basically click on the dispalyed range then go to design and change chart type, i think i would build the stacked as default then change the non stacked, depends a bit on the data and how it is laid out