Barcharts With 2 'Y' Axis?

[dapoole]

Hi Guru

How do I graphically represent 'Mb' and '%' on the same bar chart? I want to display actual Mb growth and percentage growth on the same bar chart. For example the Mb values on the left vertical axis and % on the right vertical axis such as :

Mb | | %
|____ |
| | |
| | ____ |
| | | | |
|-----| | | |
| | | | |
| | |-----| |
|____|__|____|________|
db1 db2

Using data like:


db name | Total Size Mb | Weekly Growth % |
---------------------------------------------------
db1 | 1000 | 45.00
db2 | 800 | 25.00


Any help greatly appreciated.

Cheers
David

 

[dapoole]

Oops the example chart hasnt been outputed correctly but hopefully you know what I mean.

 

[jdee]

You could use custom chart on two axes. Go to custom, choose column line on 2 axes, create chart, change the line after to column chart. Should do what you are asking.