Bar Graphs

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.
>