| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Month as Axis entry
I have a line chart with data for each day of the year.
I want the X axis instead of showing every day to show only the respective month once for all the possible occurrences within that month. In other words if I have data for 1/5/09, 1/7/09, 1/15/09 ect instead of showing every day in X I would like to show Jan once. Thanks in advance |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Month as Axis entry
Format Axis/ Scale:
Major unit: 1 Month(s) -- David Biddulph "LuisE" wrote in message ... I have a line chart with data for each day of the year. I want the X axis instead of showing every day to show only the respective month once for all the possible occurrences within that month. In other words if I have data for 1/5/09, 1/7/09, 1/15/09 ect instead of showing every day in X I would like to show Jan once. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Latest Entry For Each Month | Excel Discussion (Misc queries) | |||
| In a range of months can I capture the most current month entry? | Excel Discussion (Misc queries) | |||
| same month/day on x axis for multiple years | Charts and Charting in Excel | |||
| How do I count the # of times an entry has been made in a month? | New Users to Excel | |||
| grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Linear Mode
