Stacked chart - Need overlapping!!!

  • Thread starter Thread starter Mayur
  • Start date Start date
M

Mayur

I have created a chart that has multiple data.

Goal - 2000000
Present - 4,500,000
January - 450,000

I have the column stacked on top of each other.

BUT THE PROBLEM IS that if someone is reading the graph they think that
presently we are at 6,500,000. Because the goal is below it @ 2,000,000 and
it adds the presently on top of it.

I need them to over lap each other. So the numbers on the left are correct.
I have used a stacked column graph.
 
Hi,

Don't stack the columns then. Use Cluster column chart type instead.
Set the overlap value to 100.

Cheers
Andy
 
Back
Top