Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic charting
I have a scatter chart (curved lines) that are based on data in cells a6
through v10, with column "A" being the 4 series names and row 6 being temperatures. The user inputs a temperature that goes into b6, and the rest of row 6 populates by adding 5 degrees to the previous. If the input is "0", I get a nice graph with four lines from 0 to 100 degrees, and the "Y" axis adjusts to accomodate the high values. If the input is 50, It shows blank from 0 degrees to 50 degrees, then a nice chart but only until 100 (not getting to 150 which is now in "V". How can I fix this so that the entire range of 21 temperatures always show, starting with whatever is input, or better yet, allow the user to input the number of temperatures he wants shown, by inputtint in J17. (But without a blank range from zero to his temperature). I've tried a few of the related tutorials, and can't adapt them, maybe because they are vertical instead of horizontal, and because they are a single column, not 4 lines. any suggestions? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic charting
Well, you haven't indicated what you've done so far or what the nature of
the problem is. because they are vertical instead of horizontal The OFFSET formula has five parameters: =OFFSET(Reference, Row Offset, Column Offset, Row Count, Column Count) Switch the row and column parameters to get a horizontal range. because they are a single column, not 4 lines You need a named range for each distinct range required for all of the series. This usually means one name for the X values, and one for the Y values of each series, so in general you'd need five named ranges for four series, assuming they share X. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "widman" wrote in message ... I have a scatter chart (curved lines) that are based on data in cells a6 through v10, with column "A" being the 4 series names and row 6 being temperatures. The user inputs a temperature that goes into b6, and the rest of row 6 populates by adding 5 degrees to the previous. If the input is "0", I get a nice graph with four lines from 0 to 100 degrees, and the "Y" axis adjusts to accomodate the high values. If the input is 50, It shows blank from 0 degrees to 50 degrees, then a nice chart but only until 100 (not getting to 150 which is now in "V". How can I fix this so that the entire range of 21 temperatures always show, starting with whatever is input, or better yet, allow the user to input the number of temperatures he wants shown, by inputtint in J17. (But without a blank range from zero to his temperature). I've tried a few of the related tutorials, and can't adapt them, maybe because they are vertical instead of horizontal, and because they are a single column, not 4 lines. any suggestions? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic charting
Guess I'll take a break and come back to it, cause it is not making sense
yet, even with MS help and following errors. "Jon Peltier" wrote: Well, you haven't indicated what you've done so far or what the nature of the problem is. because they are vertical instead of horizontal The OFFSET formula has five parameters: =OFFSET(Reference, Row Offset, Column Offset, Row Count, Column Count) Switch the row and column parameters to get a horizontal range. because they are a single column, not 4 lines You need a named range for each distinct range required for all of the series. This usually means one name for the X values, and one for the Y values of each series, so in general you'd need five named ranges for four series, assuming they share X. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "widman" wrote in message ... I have a scatter chart (curved lines) that are based on data in cells a6 through v10, with column "A" being the 4 series names and row 6 being temperatures. The user inputs a temperature that goes into b6, and the rest of row 6 populates by adding 5 degrees to the previous. If the input is "0", I get a nice graph with four lines from 0 to 100 degrees, and the "Y" axis adjusts to accomodate the high values. If the input is 50, It shows blank from 0 degrees to 50 degrees, then a nice chart but only until 100 (not getting to 150 which is now in "V". How can I fix this so that the entire range of 21 temperatures always show, starting with whatever is input, or better yet, allow the user to input the number of temperatures he wants shown, by inputtint in J17. (But without a blank range from zero to his temperature). I've tried a few of the related tutorials, and can't adapt them, maybe because they are vertical instead of horizontal, and because they are a single column, not 4 lines. any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Charting Question re data | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Dynamic Charting Question | Charts and Charting in Excel | |||
excel dynamic charting | Excel Discussion (Misc queries) | |||
Dynamic charting problems (events) | Charts and Charting in Excel |