Axis category

[Svilen Pachedzhiev]

Hi,

Is there a way in Excel's charts to make axis category = time, but when
charting to make it skip weekends or the days where are no data.

I need this because I want to have this option for choosing time period
between two dates. When I make axis category = category, this option
disappears.

Regards,

Svilen

[Jon Peltier]

I'm afraid it's either-or. If you choose a time scale, it plots every
day within the range, including weekends. Otherwise it would be like an
XY chart that omits numbers ending in "5".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Svilen Pachedzhiev wrote:
> Hi,
>
> Is there a way in Excel's charts to make axis category = time, but when
> charting to make it skip weekends or the days where are no data.
>
> I need this because I want to have this option for choosing time period
> between two dates. When I make axis category = category, this option
> disappears.
>
> Regards,
>
> Svilen
>
>

[Svilen Pachedzhiev]

Thanks!

Svilen

"Jon Peltier" <[email protected]> wrote in message
news:[email protected]...
I'm afraid it's either-or. If you choose a time scale, it plots every
day within the range, including weekends. Otherwise it would be like an
XY chart that omits numbers ending in "5".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Svilen Pachedzhiev wrote:
> Hi,
>
> Is there a way in Excel's charts to make axis category = time, but when
> charting to make it skip weekends or the days where are no data.
>
> I need this because I want to have this option for choosing time period
> between two dates. When I make axis category = category, this option
> disappears.
>
> Regards,
>
> Svilen
>
>