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]

Thanks!

Svilen

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/
_______