| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph errors
I am plotting a graph with daily data but there will be no data on Sunday
since its a holiday then the data again entered on Monday but when you notice the graph due to no values on Sunday it looks, the is a gap formed between Saturday and Monday how do I join Saturday to Monday without hiding or entering 0 (zero) under Sunday. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Graph errors
Hi,
You need to use a category axis rather than time-series. Excel will use Time series is your axis labels are dates. To switch back to category right click chart and pick Chart Options. On the Axes tab set X axis to category. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "KVK" wrote in message ... I am plotting a graph with daily data but there will be no data on Sunday since its a holiday then the data again entered on Monday but when you notice the graph due to no values on Sunday it looks, the is a gap formed between Saturday and Monday how do I join Saturday to Monday without hiding or entering 0 (zero) under Sunday. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Linear Mode
