Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create different scales on Excel charts?
I want to create two different scales in metric and imperial. Is this possible
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create different scales on Excel charts?
You can do this using primary and secondary axes. In order to get a
secondary axis, you need a second series. It can be a dummy series formatted to be hidden. Before hiding it, however, double click on it, and on the Axis tab of the dialog select Secondary. Format the secondary axis as desired, and calculate the maximum scale value you need so that the axes properly line up. This will not occur automatically in Excel. You either need to do it manually or through use of a macro. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris H" <Chris wrote in message ... I want to create two different scales in metric and imperial. Is this possible |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create different scales on Excel charts?
Thank you. I have now got this for the Y axis how can I do the same for the
X axis? Chris H "Jon Peltier" wrote: You can do this using primary and secondary axes. In order to get a secondary axis, you need a second series. It can be a dummy series formatted to be hidden. Before hiding it, however, double click on it, and on the Axis tab of the dialog select Secondary. Format the secondary axis as desired, and calculate the maximum scale value you need so that the axes properly line up. This will not occur automatically in Excel. You either need to do it manually or through use of a macro. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris H" <Chris wrote in message ... I want to create two different scales in metric and imperial. Is this possible |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create different scales on Excel charts?
Make sure it's an XY chart. If you have a secondary Y axis, go to Chart menu
Chart Options Axes tab, and check the option for a secondary X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris H" wrote in message ... Thank you. I have now got this for the Y axis how can I do the same for the X axis? Chris H "Jon Peltier" wrote: You can do this using primary and secondary axes. In order to get a secondary axis, you need a second series. It can be a dummy series formatted to be hidden. Before hiding it, however, double click on it, and on the Axis tab of the dialog select Secondary. Format the secondary axis as desired, and calculate the maximum scale value you need so that the axes properly line up. This will not occur automatically in Excel. You either need to do it manually or through use of a macro. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris H" <Chris wrote in message ... I want to create two different scales in metric and imperial. Is this possible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Excel should heavily extend the options for black-white charts | Charts and Charting in Excel | |||
Excel Charts | Charts and Charting in Excel | |||
Can't create dynamic charts | Charts and Charting in Excel |