Bar Chart Scale

Can you have different scales on a bar chart. I want to chart sales and quantity. Oracle lets you label the top of the bar chart as money and the bottom as quantity.

I am dividing my sales by one million and quantity by one thousand to make them similar in size on the same chart. I am using the sum of the sales/1000000 as a point label. Is there any way to limit the number of decimal places displayed. Currently it is displaying something like 1.94889312043; 1.95M would be better.

Thank you.

Change the format code for the X and/or Y axis to N or F.|||

I should have been more clear.

I want sales by month AND tons shipped by month to show on the same bar chart.

I can put then on the chart together. I just wondered if you could label the y axies differently.

Oracle does something like to do something like:

Sales

0.0M 20M 40M

$$$$$$$$$

Jan

ttttttttt

$$$$$$$$$$$

Feb

ttttttttt

$$$$$

Mar

ttt

0.0K 50K 100K

Net Tons Shipped