Bar Charts in Excel 2007

[RAMACHANDRAN K]

I have to draw bar charts in Excel 2007. By considering three parameters (Target , Actual and Difference ) , I have to draw bar chart in excel which shall displays Target as one bar and actual , difference in the second bar with different colours. Please help.


Regards

Ramachandran K

 

[dan_l]

Maybe try this?


http://chandoo.org/wp/tag/thermometer-charts/

 

[RAMACHANDRAN K]

Hi


Thanks for the information. I have tried the same. But i have to display the difference in the bar chart( Target - Actual). Any possibility of doing the same. ( Main intention is to display the chart label of Target , Actual and Difference)


Regards

K.Ramachandran

 

[NARAYANK991]

Hi ,


In the same chart , you can have a combination of a column chart ( individual columns or a stacked column ) and a line chart.


Just plot all the three series in one chart , select any one series and change its type to a line chart.


Will this do ?


Narayan