LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 18
Default How to remove weekends from the chart

I am trying to create a very simple chart with the "Dates" on the x-axis and
"Data" on the y-axis.

Since i do not have any data on the weekends i do not have that in the list
from where the chart is being made, however the chart always shows up the
weekends as well, with the entry being blank. Data as below:

date data
2-Feb-09 5
3-Feb-09 7
4-Feb-09 19
5-Feb-09 12
6-Feb-09 14
9-Feb-09 18
10-Feb-09 10
11-Feb-09 11
12-Feb-09 4
13-Feb-09 5

I want to know if there is a way to remove the weekends with the blank data
from the Charts
 
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
Remove weekends from a Chart Ross12345 Excel Discussion (Misc queries) 0 August 12th 08 10:03 AM
Eliminate weekends on chart looloo Excel Discussion (Misc queries) 1 June 8th 07 08:55 PM
Remove weekends from a stock chart pb Charts and Charting in Excel 4 April 14th 07 08:56 PM
How to remove weekends from chart in Excel 2007 ? GPS Charts and Charting in Excel 1 April 13th 07 02:34 PM
Chart with colored weekends Jose Lopes Charts and Charting in Excel 0 March 7th 06 10:53 PM


All times are GMT +1. The time now is 04:04 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"