Bar Charts with variation

[Samir69]

Hello Forum,

I am interested by the charts #6 (Nixnut) of the link below.

http://chandoo.org/wp/2008/11/14/excel-charting-alternatives-market-share-data/

Do you know how i can build the chart (vertival bars) with the variation in % ?

Thanks

 

[NARAYANK991]

Hi Samir ,

Can you upload a file with data ?

Narayan

 

[Samir69]

Hi Naryank

Attached the file with the data

Thanks

 

[NARAYANK991]

Hi Samir ,

I do not know whether there is any easier way of doing this , but this is one way.

Narayan

 

[Samir69]

Hi Narayan,

Many thanks for your return and your proposition which work very well

Would it be possible to integrated a third graph such a curve in order to show the target updated in the data

Thanks

 

[NARAYANK991]

Hi Samir ,

I think it's going to be difficult to combine a line chart with the existing 2 bar charts ; it is possible a second chart can be superimposed on the earlier one. Give me some time.

Narayan

 

[Samir69]

Hi Narayan

See attached what i search in a horizontal way

Thanks

 

[NARAYANK991]

Hi Samir ,

That is because you have used a column chart and not a bar chart ; try combining the line chart with the earlier bar chart.

An alternative is to superimpose a line chart on the existing bar chart , but it will take a lot of data rearrangement. See here :

http://peltiertech.com/Excel/Charts/BarLineCombo.html

Narayan