charting using height AND width

Hello all,

I am trying to work out how I could chart the following example:

SERIES VALUE 1 VALUE 2
A 10.5 150
B 11 100
C 15 50
D 12 200

I would like to represent the data in columns where the height of the column is the value 1 (eg 10.5 for Series A) and the width of the column is the value 2 (eg 150 for Series A.)

I have had no luck so far and any assistance would be kindly appreciated.

Thanks in advance.

Originally Posted by heski

Hello all,

I am trying to work out how I could chart the following example:

SERIES VALUE 1 VALUE 2
A 10.5 150
B 11 100
C 15 50
D 12 200

I would like to represent the data in columns where the height of the column is the value 1 (eg 10.5 for Series A) and the width of the column is the value 2 (eg 150 for Series A.)

I have had no luck so far and any assistance would be kindly appreciated.

Thanks in advance.

The attached might help, but the 'pattern' is spread over only 25 points for display.

For greater accuracy, allocate more cells (downwards if you need more than 250) and re-adjust the formula to suit.

I didn't set the legends etc, I presume you know most of a chart.

hth
---

Much appreciated!