Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart formatting with dates
I made a chart that has dates on the x-axis. The dates are not in consecutive order (ie Jan 5, Feb 8, etc). Excel defaults the axis format such that the dates fall in consecutive order and thus, makes my plot uneven. How do I format so that the exact dates I've entered into the cells show up on the x axis without adding any extra dates? Thanks Paula -- paulabrozek ------------------------------------------------------------------------ paulabrozek's Profile: http://www.excelforum.com/member.php...o&userid=30377 View this thread: http://www.excelforum.com/showthread...hreadid=535107 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart formatting with dates
Choose Chart Options from the Chart menu, click on the Axes tab, and choose
Categories instead of Automatic under Category (X) Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "paulabrozek" wrote in message ... I made a chart that has dates on the x-axis. The dates are not in consecutive order (ie Jan 5, Feb 8, etc). Excel defaults the axis format such that the dates fall in consecutive order and thus, makes my plot uneven. How do I format so that the exact dates I've entered into the cells show up on the x axis without adding any extra dates? Thanks Paula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Dates on X Axis | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
How do I chart date ranges with varying start and finish dates? | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |