Axis category
 

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

Axis category
 

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

Axis category
 

Thanks!

Svilen

"Jon Peltier" wrote in message
...
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