Home |
Search |
Today's Posts |
#1
|
|||
|
|||
chart with dates on the x-axe
how can you change the x-axe into a text x-as when the data are dates ? on specific dates a want to show a specific value. When I want to create e.g. a line-type chart, the values are ok, but the x-axe with the dates becomes a time-ax in stead of showing the real dates from the data. Is there a way to change the dates into text, without making it explicit text (with a ') because I want to use them also for calculating things. ??? -- chriske ------------------------------------------------------------------------ chriske's Profile: http://www.excelforum.com/member.php...o&userid=27506 View this thread: http://www.excelforum.com/showthread...hreadid=470202 |
#2
|
|||
|
|||
Hi,
Right click the chart and pick Chart Options. On the axis tab is the option to specify Category axis rather than Automatic or Time Series. Cheers Andy chriske wrote: how can you change the x-axe into a text x-as when the data are dates ? on specific dates a want to show a specific value. When I want to create e.g. a line-type chart, the values are ok, but the x-axe with the dates becomes a time-ax in stead of showing the real dates from the data. Is there a way to change the dates into text, without making it explicit text (with a ') because I want to use them also for calculating things. ??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Chart with dates in 5 day working week only | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) |