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 |
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 |
All times are GMT +1. The time now is 04:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com