chart with different sets of % at X & Y axis

**clng** · 03-09-2007, 04:12 AM

Hi,

I had this nagging issue that would like to request for help.

I need to create a chart that on the X-axis, shows the 100% contribution of e.g. 5 product lines. Hence, the larger the sales % of the product line, the bar will be fatter. But those bar must be represented at the Y axis the growth % of each individual product lines.

Can this be done?

Thanks in advance.

**Carim** · 03-09-2007, 04:31 AM

Hi,

Take a look at Jon's brickyard chart ...
http://peltiertech.com/Excel/Charts/Brickyard.html

**clng** · 03-09-2007, 04:38 AM

Hi Carim,

Thanks for the reference link. The chart is okay but it does not show individual growth % on the Y axis (as preferred), instead it is showing like a waterfall chart

And for the x-axis data should be starting from 0 (zero) as per normal column chart bar.

Is it possible?

Thanks again.

**Carim** · 03-09-2007, 09:03 AM

Hi,

Since I am not 100% sure about the graph you need,
do you have a picture which would illustrate your objective ...?

**oldchippy** · 03-09-2007, 09:11 AM

Originally Posted by clng

Hi Carim,

Thanks for the reference link. The chart is okay but it does not show individual growth % on the Y axis (as preferred), instead it is showing like a waterfall chart

And for the x-axis data should be starting from 0 (zero) as per normal column chart bar.

Is it possible?

Thanks again.

Here's a waterfall chart if you need one?

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

**clng** · 03-11-2007, 09:26 PM

Carim & Oldchippy,

Thanks for replying to my post. I am sorry to post back late.

Anyway, here is the sketch of my requirements. On the X-axis, the width of the bar will need to correspond to the % or the value of the data. The larger the data, the bar width will be wider. As for the Y-axis, it will reflect the growth % of each individual bar as per data entry.

Is it possible?

Thanks again.