Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Chart problem with dates

Hi,

I am creating a chart that has week day information only, but when the chart
is formed, the weekends are included. Is there a way to exclude the
weekends? There is no weekend information in the chart data area.

Thank you,
Janel
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Chart problem with dates

Hi,

In order to exclude dates that do not have data you can set the axis to
be categorical. This will plot a point for each date which will be
equally spaced.

Right click chart and pick Chart Options from the context menu. On the
scale tab set the axis type to category.

Cheers
Andy

Janel wrote:
Hi,

I am creating a chart that has week day information only, but when the chart
is formed, the weekends are included. Is there a way to exclude the
weekends? There is no weekend information in the chart data area.

Thank you,
Janel

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dates problem mita Excel Discussion (Misc queries) 4 June 2nd 06 12:19 PM
Dates Problem nicole0904 Excel Discussion (Misc queries) 5 May 10th 06 02:47 PM
How do I get the dates on an excel chart to stay as dates instead. Rani Charts and Charting in Excel 1 September 20th 05 05:56 PM
Problem Dates Andy Cohen Excel Discussion (Misc queries) 1 September 16th 05 01:29 AM
Problem with dates Emece Excel Worksheet Functions 7 December 22nd 04 06:47 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"