Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mayur" wrote in message
...
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.