Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to remove weekends from the chart
Hi,
You need to plot the axis as category rather than Time series. xl2003 - Chart Options Axes Category xl2007 - Format axis Axis Options Text Axis Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Saran" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to remove weekends from the chart
Hi Andy,
Your solution worked like a charm. Thanks Cheers Saran "Andy Pope" wrote: Hi, You need to plot the axis as category rather than Time series. xl2003 - Chart Options Axes Category xl2007 - Format axis Axis Options Text Axis Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Saran" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove weekends from a Chart | Excel Discussion (Misc queries) | |||
Eliminate weekends on chart | Excel Discussion (Misc queries) | |||
Remove weekends from a stock chart | Charts and Charting in Excel | |||
How to remove weekends from chart in Excel 2007 ? | Charts and Charting in Excel | |||
Chart with colored weekends | Charts and Charting in Excel |