Axis category

  • Thread starter Thread starter Svilen Pachedzhiev
  • Start date Start date
S

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