Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart Date X Axis
I currently have a chart with an x axis that is dates. The dates aren't
in order in the supporting table but display in order on the chart which is great. Is there a way of appending some text to each date field and having the date and text displayed on the x axis and having Excel order the dates in chronological order. ie in the table 10 Apr 04-1 15 Feb 04-5 20 May 04-2 31 Jan 04-4 would still print in date order. Thanks... |
#2
|
|||
|
|||
MrC wrote:
I currently have a chart with an x axis that is dates. The dates aren't in order in the supporting table but display in order on the chart which is great. Is there a way of appending some text to each date field and having the date and text displayed on the x axis and having Excel order the dates in chronological order. ie in the table 10 Apr 04-1 15 Feb 04-5 20 May 04-2 31 Jan 04-4 would still print in date order. Thanks... Sorry, "would still print in date order" should say "would display in date order along the x axis of the chart" |
#3
|
|||
|
|||
Excel uses the values as dates if it recognizes their date format. As
soon as you append text, their format is no longer a date, and you lose the ability to sort by date order. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ MrC wrote: I currently have a chart with an x axis that is dates. The dates aren't in order in the supporting table but display in order on the chart which is great. Is there a way of appending some text to each date field and having the date and text displayed on the x axis and having Excel order the dates in chronological order. ie in the table 10 Apr 04-1 15 Feb 04-5 20 May 04-2 31 Jan 04-4 would still print in date order. Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |