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