Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting my chart to display dates
i have two different values that i am charting on a scatter plot; projected
value and actual value for each month. I want my X axis to be the months. For some reason when I go to format the axis it is showing the dates as the number code and is givng me no option to show each month. i can use the number code and set a maximum and minimum date but when i set a 30 day increment it duplicates a month over a long period of time. How do I get the axis to recognize that those are days and chart th value for each month? I want all the months to be displayed on the x axis. I hope this makes sense. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting my chart to display dates
Since none of you answered me:
Todd, what you need to do is not make a scatter plot and do a line chart insted. They have a line chart that is specific for date and time. Todd, if this helped please click yes. sincerely Todd "Todd" wrote: i have two different values that i am charting on a scatter plot; projected value and actual value for each month. I want my X axis to be the months. For some reason when I go to format the axis it is showing the dates as the number code and is givng me no option to show each month. i can use the number code and set a maximum and minimum date but when i set a 30 day increment it duplicates a month over a long period of time. How do I get the axis to recognize that those are days and chart th value for each month? I want all the months to be displayed on the x axis. I hope this makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a chart to only display the dates in my table? | Charts and Charting in Excel | |||
Display a value between certain dates | Excel Worksheet Functions | |||
Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
How to display a series in chart table and not in the chart? | Charts and Charting in Excel | |||
How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel |