[Excel] Variable Width Bar Chart
Solved
netman44
Posted messages
65
Status
Membre
-
irem -
irem -
Hello,
Is it possible to create a bar chart (or histogram) with bars of different widths (which would depend for example on the "weight" of each bar in the total)?
Example: I have 3 countries where I sell 100, 150, and 120 units per year respectively. I have 200 clients in country 1, 300 in country 2, and 500 in country 3. I would like my histogram to represent three bars of 100, 150, and 120 in height over 200, 300, and 500 in width respectively.
Thank you.
Netman
Is it possible to create a bar chart (or histogram) with bars of different widths (which would depend for example on the "weight" of each bar in the total)?
Example: I have 3 countries where I sell 100, 150, and 120 units per year respectively. I have 200 clients in country 1, 300 in country 2, and 500 in country 3. I would like my histogram to represent three bars of 100, 150, and 120 in height over 200, 300, and 500 in width respectively.
Thank you.
Netman
Configuration: Windows XP Internet Explorer 6.0