Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show yyyy only on x axis of a chart?
I did not use a formula for the date (4-digit year only) in column A, I
manually entered the years. When I attempt to create a chart, the years either show up as 1, 2, 3, etc or as m/d/yyyy with the year showing in all instances as 1900. Can you help me enter the yyyy only on the x axis of the chart? Unfortunately there is no option for yyyy in "format cellsdate". |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show yyyy only on x axis of a chart?
Hi,
The answer depends on the version of Excel you are using. 2003: Select the chart and choose Chart, Source Data, Series tab, and delete the Year series from the Series box. Then select the Category (X) axis labels box and highlight the range containing the years. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "JeanEM" wrote: I did not use a formula for the date (4-digit year only) in column A, I manually entered the years. When I attempt to create a chart, the years either show up as 1, 2, 3, etc or as m/d/yyyy with the year showing in all instances as 1900. Can you help me enter the yyyy only on the x axis of the chart? Unfortunately there is no option for yyyy in "format cellsdate". |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show yyyy only on x axis of a chart?
If you are making a line chart with data such as this
Year Sales 2004 1234 2005 2456 .... Excel will treat both columns as data series and the x-axis will be 1,2,3, If you delete the text "Year" than make the chart, Excel will see the first column as you category values. You can add the text back in after making the chart Alternatively, make an XY chart best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "JeanEM" wrote in message ... I did not use a formula for the date (4-digit year only) in column A, I manually entered the years. When I attempt to create a chart, the years either show up as 1, 2, 3, etc or as m/d/yyyy with the year showing in all instances as 1900. Can you help me enter the yyyy only on the x axis of the chart? Unfortunately there is no option for yyyy in "format cellsdate". |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show yyyy only on x axis of a chart?
Worked perfectly! Thank you Shane.
"Shane Devenshire" wrote: Hi, The answer depends on the version of Excel you are using. 2003: Select the chart and choose Chart, Source Data, Series tab, and delete the Year series from the Series box. Then select the Category (X) axis labels box and highlight the range containing the years. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "JeanEM" wrote: I did not use a formula for the date (4-digit year only) in column A, I manually entered the years. When I attempt to create a chart, the years either show up as 1, 2, 3, etc or as m/d/yyyy with the year showing in all instances as 1900. Can you help me enter the yyyy only on the x axis of the chart? Unfortunately there is no option for yyyy in "format cellsdate". |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show yyyy only on x axis of a chart?
Hi Shane
Many thanks for that - worked a dream!! Why do the simple things in Excel always involve more more than we think and take much longer than we imagine!!! "Shane Devenshire" wrote: Hi, The answer depends on the version of Excel you are using. 2003: Select the chart and choose Chart, Source Data, Series tab, and delete the Year series from the Series box. Then select the Category (X) axis labels box and highlight the range containing the years. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "JeanEM" wrote: I did not use a formula for the date (4-digit year only) in column A, I manually entered the years. When I attempt to create a chart, the years either show up as 1, 2, 3, etc or as m/d/yyyy with the year showing in all instances as 1900. Can you help me enter the yyyy only on the x axis of the chart? Unfortunately there is no option for yyyy in "format cellsdate". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show only workdays in chart axis? | Charts and Charting in Excel | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? | Excel Discussion (Misc queries) | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
Show quarters and years on x axis of a chart | Charts and Charting in Excel |