Thanks for your help. I ended up changing the X axis to "category" and it
allowed me to display the specific months I wanted.
Fadila
"Jon Peltier" wrote:
To use a time scale axis, you need to retain all of the dates within the
span of time. There's no way to hide/delete certain months.
If you don't have many gaps, you could apply this technique to the X axis:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
F. P. wrote:
Using the time scale option (for x-axis), is there any way to hide/delete
specific months that have no data after selecting the min and max.