| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart filling in dates that aren't supposed to be there
I have created a table where the values are measured only during week-days.
The problem is that the Excel line chart created from the table's data wants to automatically fill in values for the weekend as well. Thus, if the data range is from columns I through N, representing May 30, June 2, June 3, June 4, June 5, June 6 and June 9, the chart automatically fills in values for May 31, June 1 and June 7 and June 8. How do I get the chart to just represent the dates I have entered, and not extrapolate for every day of the week? -- Geoff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling in specific dates in Excel | Excel Discussion (Misc queries) | |||
| Excel If statement that is supposed to return a "" instead returns a 0 | Excel Worksheet Functions | |||
| Filling in missing dates | Excel Worksheet Functions | |||
| When I publish a web page that's supposed to be interactave it be. | Excel Discussion (Misc queries) | |||
| Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
Threaded Mode
