| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart data
I have a spreadsheet set up that updates the information every month over a
12 month period. The data i have for example is Actual Profile Jan 77723 77723 Feb 75319 67582 Mar 72047 73469 Apr 69557 81048 May 76672 88563 Jun 65068 77750 Jul 63819 79528 Aug 71079 90357 Sep 65793 85348 0 0 0 0 0 0 0 0 0 Obviously i have not received the data for the last three months yet but i need to keep the formulas in to automatically update the information. I want to select all of the information in this area but not show zeros on my chart. This chart will then update every month as the data updates. Is this possible to do. Please can someone help me. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
| Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
Threaded Mode
