Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Axis in Excel 2007
Hello,
I am trying to change the format of the Axis in my chart to a number format but for some reason it will not work. The data that my chart is based on is in Number format, the Axis is percentage format. I've tried everything I can think of and nothing seems to work. Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Axis in Excel 2007
In EXCEL 2007 check the following for the axis with which you are having a
problem:- 1. Click on the axis with which you are having a problem (I have clicked on the Y axis which is formatted as Number in my underlying data). 2. Chart Tools / Format / Current Selection group / Vertical (Value) Axis - you might need to change this setting to whichever axis it is you are having a problem with) / Format Selection / Format Axis window should now launch / Number / make sure that Number is selected and not Percentage. If my comments have helped please hit Yes. Thanks. "Lizz45ie" wrote: Hello, I am trying to change the format of the Axis in my chart to a number format but for some reason it will not work. The data that my chart is based on is in Number format, the Axis is percentage format. I've tried everything I can think of and nothing seems to work. Any help will be greatly appreciated. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Axis in Excel 2007
Hi,
The instructions doesn't apply to my chart because it is tied to a pivot table. I don't see the menu for the Chart Tools. Is there a work around to change the number format in a chart that is tied a pivot table? "trip_to_tokyo" wrote: In EXCEL 2007 check the following for the axis with which you are having a problem:- 1. Click on the axis with which you are having a problem (I have clicked on the Y axis which is formatted as Number in my underlying data). 2. Chart Tools / Format / Current Selection group / Vertical (Value) Axis - you might need to change this setting to whichever axis it is you are having a problem with) / Format Selection / Format Axis window should now launch / Number / make sure that Number is selected and not Percentage. If my comments have helped please hit Yes. Thanks. "Lizz45ie" wrote: Hello, I am trying to change the format of the Axis in my chart to a number format but for some reason it will not work. The data that my chart is based on is in Number format, the Axis is percentage format. I've tried everything I can think of and nothing seems to work. Any help will be greatly appreciated. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Axis in Excel 2007
Hi Lizz.
I have just checked to see if the instructions that I have already give apply to Pivot Charts as well and they do. A Pivot Chart does not seem to work any differently from a, "normal" chart (I believe they must, therefore, use the same underlying software). So what I have said still applies to the situation in which you find yourself. The menu for (the now) PivotChart Tools is found towards the top right hand part of your screen. PivotChart Tools will appear in the Title Bar (top right hand side) and beneath this (on the right hand side) you will find the Design Layout Format and Analyze options. Hope you can find it now. If my comments have helped please hit Yes. Thanks. "Lizz45ie" wrote: Hi, The instructions doesn't apply to my chart because it is tied to a pivot table. I don't see the menu for the Chart Tools. Is there a work around to change the number format in a chart that is tied a pivot table? "trip_to_tokyo" wrote: In EXCEL 2007 check the following for the axis with which you are having a problem:- 1. Click on the axis with which you are having a problem (I have clicked on the Y axis which is formatted as Number in my underlying data). 2. Chart Tools / Format / Current Selection group / Vertical (Value) Axis - you might need to change this setting to whichever axis it is you are having a problem with) / Format Selection / Format Axis window should now launch / Number / make sure that Number is selected and not Percentage. If my comments have helped please hit Yes. Thanks. "Lizz45ie" wrote: Hello, I am trying to change the format of the Axis in my chart to a number format but for some reason it will not work. The data that my chart is based on is in Number format, the Axis is percentage format. I've tried everything I can think of and nothing seems to work. Any help will be greatly appreciated. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Axis in Excel 2007
Lizz45ie -
For an Excel 2007 PivotChart, to change a numerical axis format, select the PivotChart, choose PivotChart Tools | Layout | Axes | Primary Horiz/Vert Axis | More Primary Horiz/Vert Axis Options, and in the Format Axis dialog box choose Number ... - Mike http://www.MikeMiddleton.com "Lizz45ie" wrote in message ... Hello, I am trying to change the format of the Axis in my chart to a number format but for some reason it will not work. The data that my chart is based on is in Number format, the Axis is percentage format. I've tried everything I can think of and nothing seems to work. Any help will be greatly appreciated. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Axis in Excel 2007
Hi - I am trying to format x-axis in a pivot chart from m/d/y to mmm-yy. I
set the format to mmm-yy but it still appears as m/d/y. Even when I open the format window for the primary horizontal axis, the mmm-yy format is selected but the x-axis still displays m/d/yy. Any ideas of what to check next? thank you! "Mike Middleton" wrote: Lizz45ie - For an Excel 2007 PivotChart, to change a numerical axis format, select the PivotChart, choose PivotChart Tools | Layout | Axes | Primary Horiz/Vert Axis | More Primary Horiz/Vert Axis Options, and in the Format Axis dialog box choose Number ... - Mike http://www.MikeMiddleton.com "Lizz45ie" wrote in message ... Hello, I am trying to change the format of the Axis in my chart to a number format but for some reason it will not work. The data that my chart is based on is in Number format, the Axis is percentage format. I've tried everything I can think of and nothing seems to work. Any help will be greatly appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the scale (extend) the X axis in Excel 2007? | Charts and Charting in Excel | |||
Excel 2007 - change interval between labels on X axis | Charts and Charting in Excel | |||
How to you change the axis label position in office 2007? | Charts and Charting in Excel | |||
Change Axis titles in Excel 2007 | Excel Discussion (Misc queries) | |||
2 axis in excel 2007 | Charts and Charting in Excel |