|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 3rd, 2005, 01:14 PM
|
|||
|
|||
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
November 5th, 2005, 03:18 AM
|
|||
|
|||
|
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
November 7th, 2005, 08:33 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dynamic Bar Chart Category Axis Problem | Richard | Charts and Charting | 1 | September 13th, 2005 09:51 AM |
| How do I make the Y axis in an excel chart the category axis? | megnadoodle | Charts and Charting | 2 | March 29th, 2005 09:27 AM |
| X Axis Category Label not appearing | Janna | Charts and Charting | 0 | February 13th, 2004 09:41 PM |
| Category axis problem | Giel Weysters | Charts and Charting | 1 | November 29th, 2003 04:52 AM |
| x axis category name | Jen | Charts and Charting | 3 | October 21st, 2003 01:22 PM |
Linear Mode
