Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
X-Y Graph with Months, Not Date on Axis
I have a data set with dates in column A and values in column B. I
have this plotted as an X-Y graph. I can change the major units on the X (date) axis, but only by integers. I would like for it to display months, rather than equally spaced dates. The closest I can do, is to use 30 days for the major unit on the X-axis. Is it possible to have each month displayed rather than specific date in 30 day increments? Bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
X-Y Graph with Months, Not Date on Axis
Hi,
Try the following approach; I think that it would work. If the lowest date in your data is not on the first of a month, create a dummy date which is the first of the lowet month with no y-value for it, and include that dummy point in the graph. Then Right-click on "X-axis" -- "Format Axis" --"Scale" Tab: Base Unit: select "Day(s)" Major Unit: enter "1" and select "Month(s)" Minor Unit: enter "1" and select "Month(s)" --"Number" Tab: Category: "Custom" Type: "mmm yy" (or "mmm yyyy", or any other format you want) Regards, B. R. Ramachandran "Sam Fertel" wrote: I have a data set with dates in column A and values in column B. I have this plotted as an X-Y graph. I can change the major units on the X (date) axis, but only by integers. I would like for it to display months, rather than equally spaced dates. The closest I can do, is to use 30 days for the major unit on the X-axis. Is it possible to have each month displayed rather than specific date in 30 day increments? Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i do x/y axis graph | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Formula: Date plus 3 months | Excel Discussion (Misc queries) | |||
2 axis bar graph | Excel Discussion (Misc queries) | |||
Time axis column and scatter/line graph | Charts and Charting in Excel |