ExcelBanter - Displaying Ratios in Chart scales

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Displaying Ratios in Chart scales (https://www.excelbanter.com/excel-discussion-misc-queries/106334-displaying-ratios-chart-scales.html)

Graham Tritton

Displaying Ratios in Chart scales

I want to be able to display ratios in Chart scales. eg. 1:10, 1:15, 1:20 Any
ideas

Jon Peltier

Displaying Ratios in Chart scales

You can make your own custom axis scales, using any labeling convention you
want:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Graham Tritton" wrote in message
...
I want to be able to display ratios in Chart scales. eg. 1:10, 1:15, 1:20
Any
ideas

All times are GMT +1. The time now is 08:01 PM.