Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X-Axis Labels Bar Chart
How to I format individual x-axis labels. For example my time series is
2007, 2009,2009. I want to format the time line into 2007. 2008E, 2009E. When I customize the 0"E" in in format numbers, I get 2007E, 200E, 2009E. I can't select individual labels. Any advice? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X-Axis Labels Bar Chart
Hi,
Select the range in the spreadsheet with the years and choose Format, Cells, Custom and on the Type line enter General"E" You can apply this to the entire range or just some of the cells. -- Thanks, Shane Devenshire "Pluto" wrote: How to I format individual x-axis labels. For example my time series is 2007, 2009,2009. I want to format the time line into 2007. 2008E, 2009E. When I customize the 0"E" in in format numbers, I get 2007E, 200E, 2009E. I can't select individual labels. Any advice? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Axis Labels | Charts and Charting in Excel | |||
Chart axis labels cut off | Excel Discussion (Misc queries) | |||
Different X-axis labels for different Series in same chart | Charts and Charting in Excel | |||
Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel |