| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Bar Chart Category Axis Problem | Charts and Charting in Excel | |||
| Category Axis placement | Charts and Charting in Excel | |||
| How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
| Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Linear Mode
