Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charts where start is known, but end is unknown
Hello,
I've recently been trying to find a solution for graphing the last 10 values in a list of data, but the problem is (I'm using Peltier's example for Dynamic Charts) is that I know where my start is (never at b1 or a1), but not my end. However anything I throw into my graphing solution is giving me random results. This is the first issue. The second issue is, I'm using the same sheet to create multiple graphs that will be using these dynamic charts, and once again it appears that the consistency in graphing is in error (aka. looks correct one minute and garbage the next) |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charts where start is known, but end is unknown
Share your dynamic name formulas, and someone might be able to help.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... Hello, I've recently been trying to find a solution for graphing the last 10 values in a list of data, but the problem is (I'm using Peltier's example for Dynamic Charts) is that I know where my start is (never at b1 or a1), but not my end. However anything I throw into my graphing solution is giving me random results. This is the first issue. The second issue is, I'm using the same sheet to create multiple graphs that will be using these dynamic charts, and once again it appears that the consistency in graphing is in error (aka. looks correct one minute and garbage the next) |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charts where start is known, but end is unknown
Yes I should have, my apologies. All of my names are similar to yours Jon
that you used in your example except here. This is the ChtCats name (All others are the same as per example) =OFFSET('Graphing Data'!$B$25,COUNTA('Graphing Data'!$B$26:$B32),0,-MIN(ChtLen,COUNTA('Graphing Data'!$B$26:$B32)),1) B25 = the name of what I'm doing (in this case date) B26 = first date (this is for a calibrated item, ideally I'd like this date to appear on the graph, but if not I think thats ok) B27-B31 = Client data, this is noted by date, and ideally I only want the last 10 of these which Jon your dynamic naming did perfectly. This list will grow continually as more clients are entered B32 = Final date that item was tested, this date is always shown (Once again Jon your formula does this great) Now this is only for 1 graph on this page, there are a total of 8 that are created from this page. (Different sets of data). "Jon Peltier" wrote: Share your dynamic name formulas, and someone might be able to help. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... Hello, I've recently been trying to find a solution for graphing the last 10 values in a list of data, but the problem is (I'm using Peltier's example for Dynamic Charts) is that I know where my start is (never at b1 or a1), but not my end. However anything I throw into my graphing solution is giving me random results. This is the first issue. The second issue is, I'm using the same sheet to create multiple graphs that will be using these dynamic charts, and once again it appears that the consistency in graphing is in error (aka. looks correct one minute and garbage the next) |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charts where start is known, but end is unknown
I also want to note (although this may be obvious) the information of B32
shifts down as data is entered in. "Rcarper" wrote: Yes I should have, my apologies. All of my names are similar to yours Jon that you used in your example except here. This is the ChtCats name (All others are the same as per example) =OFFSET('Graphing Data'!$B$25,COUNTA('Graphing Data'!$B$26:$B32),0,-MIN(ChtLen,COUNTA('Graphing Data'!$B$26:$B32)),1) B25 = the name of what I'm doing (in this case date) B26 = first date (this is for a calibrated item, ideally I'd like this date to appear on the graph, but if not I think thats ok) B27-B31 = Client data, this is noted by date, and ideally I only want the last 10 of these which Jon your dynamic naming did perfectly. This list will grow continually as more clients are entered B32 = Final date that item was tested, this date is always shown (Once again Jon your formula does this great) Now this is only for 1 graph on this page, there are a total of 8 that are created from this page. (Different sets of data). "Jon Peltier" wrote: Share your dynamic name formulas, and someone might be able to help. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... Hello, I've recently been trying to find a solution for graphing the last 10 values in a list of data, but the problem is (I'm using Peltier's example for Dynamic Charts) is that I know where my start is (never at b1 or a1), but not my end. However anything I throw into my graphing solution is giving me random results. This is the first issue. The second issue is, I'm using the same sheet to create multiple graphs that will be using these dynamic charts, and once again it appears that the consistency in graphing is in error (aka. looks correct one minute and garbage the next) |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charts where start is known, but end is unknown
I guess you know you need one name like this for each series of data.
What did you mean by the graphing solution giving "random results"? And what parts of the graph looked good one minute and garbage the next? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... I also want to note (although this may be obvious) the information of B32 shifts down as data is entered in. "Rcarper" wrote: Yes I should have, my apologies. All of my names are similar to yours Jon that you used in your example except here. This is the ChtCats name (All others are the same as per example) =OFFSET('Graphing Data'!$B$25,COUNTA('Graphing Data'!$B$26:$B32),0,-MIN(ChtLen,COUNTA('Graphing Data'!$B$26:$B32)),1) B25 = the name of what I'm doing (in this case date) B26 = first date (this is for a calibrated item, ideally I'd like this date to appear on the graph, but if not I think thats ok) B27-B31 = Client data, this is noted by date, and ideally I only want the last 10 of these which Jon your dynamic naming did perfectly. This list will grow continually as more clients are entered B32 = Final date that item was tested, this date is always shown (Once again Jon your formula does this great) Now this is only for 1 graph on this page, there are a total of 8 that are created from this page. (Different sets of data). "Jon Peltier" wrote: Share your dynamic name formulas, and someone might be able to help. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... Hello, I've recently been trying to find a solution for graphing the last 10 values in a list of data, but the problem is (I'm using Peltier's example for Dynamic Charts) is that I know where my start is (never at b1 or a1), but not my end. However anything I throw into my graphing solution is giving me random results. This is the first issue. The second issue is, I'm using the same sheet to create multiple graphs that will be using these dynamic charts, and once again it appears that the consistency in graphing is in error (aka. looks correct one minute and garbage the next) |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charts where start is known, but end is unknown
Actually this morning I think I solved the issue. I did this by putting
string notation in front of the '32'. I'm not sure why this works and that I can insert lines with no issue. Thank you for all your assistance. RC "Jon Peltier" wrote: I guess you know you need one name like this for each series of data. What did you mean by the graphing solution giving "random results"? And what parts of the graph looked good one minute and garbage the next? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... I also want to note (although this may be obvious) the information of B32 shifts down as data is entered in. "Rcarper" wrote: Yes I should have, my apologies. All of my names are similar to yours Jon that you used in your example except here. This is the ChtCats name (All others are the same as per example) =OFFSET('Graphing Data'!$B$25,COUNTA('Graphing Data'!$B$26:$B32),0,-MIN(ChtLen,COUNTA('Graphing Data'!$B$26:$B32)),1) B25 = the name of what I'm doing (in this case date) B26 = first date (this is for a calibrated item, ideally I'd like this date to appear on the graph, but if not I think thats ok) B27-B31 = Client data, this is noted by date, and ideally I only want the last 10 of these which Jon your dynamic naming did perfectly. This list will grow continually as more clients are entered B32 = Final date that item was tested, this date is always shown (Once again Jon your formula does this great) Now this is only for 1 graph on this page, there are a total of 8 that are created from this page. (Different sets of data). "Jon Peltier" wrote: Share your dynamic name formulas, and someone might be able to help. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rcarper" wrote in message ... Hello, I've recently been trying to find a solution for graphing the last 10 values in a list of data, but the problem is (I'm using Peltier's example for Dynamic Charts) is that I know where my start is (never at b1 or a1), but not my end. However anything I throw into my graphing solution is giving me random results. This is the first issue. The second issue is, I'm using the same sheet to create multiple graphs that will be using these dynamic charts, and once again it appears that the consistency in graphing is in error (aka. looks correct one minute and garbage the next) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Charts | Charts and Charting in Excel | |||
Make dynamic charts more dynamic | Charts and Charting in Excel | |||
how to make the axis of charts to start at my lowest value(data)? | Charts and Charting in Excel | |||
Dynamic Charts | Excel Discussion (Misc queries) | |||
Auto x range start value, xy charts | Charts and Charting in Excel |