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.

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.

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.