Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Progressive chart
Hello,
I have to create a chart to follow-up some data among the entire year. Obviously the values for July-Dec (for eg) are not available for the moment. Therefore the value for July-Dec are 0. A line chart will show all the values, the ones 0 from January until June, and 0 for the rest of them. I need my chart to stop in June. I tried to put <blank or N/A for the months to come but the chart still shows 0. Do you have any suggestion? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Progressive chart
You need to either make is display the #N/A error [input =NA() don't just
type N/A] or you can use dynamic charting. To do this, we need to setup a named range that defines your x-axis (months to use). Not sure how your data is setup, but you need to create a formula that counts how many months you want to use (for now, lets say the result is 7). If your x-axis data starts in A2 and goes down, go to Insert-Name-Define. Give the range a memorable name (MyRange), and input this formula: =OFFSET($A$2,0,0,7,1) Click "add" (note that the 7 is where you would either have a cell reference, or formula calculating how many months you need.) If your data runs horizontal starting in B1, change formula to: =OFFSET($B$1,0,0,1,7) Now, on your chart, go to Source Data, and for the x-axis, input this ='MyWorkbookName.xls'!MyRange Now, as the area you defined in the named range changes in size, so too will your graph. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Marius" wrote: Hello, I have to create a chart to follow-up some data among the entire year. Obviously the values for July-Dec (for eg) are not available for the moment. Therefore the value for July-Dec are 0. A line chart will show all the values, the ones 0 from January until June, and 0 for the rest of them. I need my chart to stop in June. I tried to put <blank or N/A for the months to come but the chart still shows 0. Do you have any suggestion? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Progressive chart
Hi,
the best way to handle this is by laying your data out vertically. The create your chart and apply a filter to the Date column of the data. Charts only plot visible cells by default. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Marius" wrote: Hello, I have to create a chart to follow-up some data among the entire year. Obviously the values for July-Dec (for eg) are not available for the moment. Therefore the value for July-Dec are 0. A line chart will show all the values, the ones 0 from January until June, and 0 for the rest of them. I need my chart to stop in June. I tried to put <blank or N/A for the months to come but the chart still shows 0. Do you have any suggestion? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating progressive tax | Excel Discussion (Misc queries) | |||
progressive sum | Excel Discussion (Misc queries) | |||
Progressive Calculation | Excel Worksheet Functions | |||
progressive select | Excel Worksheet Functions | |||
Progressive summing | Excel Worksheet Functions |