Home |
Search |
Today's Posts |
#1
|
|||
|
|||
more than 255 lines in chart
Is there a work-around the 255-line limit in Excel ??
Transpose won't do the trick, as I need 22 columns of data. Excel 2000 SP3, on Win XP Pro SP2. Michael |
#2
|
|||
|
|||
Hi Michael -
That's a lot of series for a chart. Is it going to be legible with so many lines? I've only ever seen one chart that really needed so many series; an experimental meteorologist needed custom curves on a chart (non-cartesian lines, like isobars). I was able to help him combine around a thousand of these curves into a few dozen. If you describe why you need all the series, someone might think of a similar way to reduce them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is there a work-around the 255-line limit in Excel ?? Transpose won't do the trick, as I need 22 columns of data. Excel 2000 SP3, on Win XP Pro SP2. Michael |
#3
|
|||
|
|||
Hi Jon,
It's a golf-program, that has worked very well untill I exceeded the number of data-rows allowed in Excel. In reality I only need maybe 15 rows of data. But as my original intentions worked, I haven't thought of it, before now. All my data are loaded to a sheet where I use AutoFilters via VB-script. So, if I ask for a certain golf-course or player the filter responds "live" to the request and updates graphs as well. I can't get the source data to accept a variable - or I'm not clever enough, and it has worked well, but now I may need data from row 1 and row 345, which is impossible, because of the limitations in Excel. Michael "Jon Peltier" wrote: Hi Michael - That's a lot of series for a chart. Is it going to be legible with so many lines? I've only ever seen one chart that really needed so many series; an experimental meteorologist needed custom curves on a chart (non-cartesian lines, like isobars). I was able to help him combine around a thousand of these curves into a few dozen. If you describe why you need all the series, someone might think of a similar way to reduce them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is there a work-around the 255-line limit in Excel ?? Transpose won't do the trick, as I need 22 columns of data. Excel 2000 SP3, on Win XP Pro SP2. Michael |
#5
|
|||
|
|||
Hi Jon,
Looks as if it's the right track !! I have been deep in to your homepage - great stuff !! and found som links to, amongst others "J-walk", who had a work-around/dynamic chart solution using "offset" and I think that it might be possible to use the existing combo/drop-down boxes I use now. Combined with extensive use of the offset-command - I might even expand the data I/O to my graphs. Thanks for helping!! Michael "Jon Peltier" wrote: Michael - Could you instead use a series of checkboxes or dropdowns to select the plotted data? Here are some examples: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Hi Jon, It's a golf-program, that has worked very well untill I exceeded the number of data-rows allowed in Excel. In reality I only need maybe 15 rows of data. But as my original intentions worked, I haven't thought of it, before now. All my data are loaded to a sheet where I use AutoFilters via VB-script. So, if I ask for a certain golf-course or player the filter responds "live" to the request and updates graphs as well. I can't get the source data to accept a variable - or I'm not clever enough, and it has worked well, but now I may need data from row 1 and row 345, which is impossible, because of the limitations in Excel. Michael "Jon Peltier" wrote: Hi Michael - That's a lot of series for a chart. Is it going to be legible with so many lines? I've only ever seen one chart that really needed so many series; an experimental meteorologist needed custom curves on a chart (non-cartesian lines, like isobars). I was able to help him combine around a thousand of these curves into a few dozen. If you describe why you need all the series, someone might think of a similar way to reduce them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is there a work-around the 255-line limit in Excel ?? Transpose won't do the trick, as I need 22 columns of data. Excel 2000 SP3, on Win XP Pro SP2. Michael |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
more than 255 lines in chart
I am hoping that someone can extend this help to me. The site did not help me
very much but maybe I am missing something. I have approximately 300 series that I need to put onto a chart. The reason I need this is that I have 300 separate sets of data that work out on a line graph to 300 distinct lines, and yes this is indeed visible and we can pull out the specific data lines we want to highlight. The problem is, I can't graph this as a single series because we have to use a range of columns for both the x and the y so I cannot graph more than one row at a time. Any help on how I might get more than 255 series? Thanks " wrote: Hi Jon, Looks as if it's the right track !! I have been deep in to your homepage - great stuff !! and found som links to, amongst others "J-walk", who had a work-around/dynamic chart solution using "offset" and I think that it might be possible to use the existing combo/drop-down boxes I use now. Combined with extensive use of the offset-command - I might even expand the data I/O to my graphs. Thanks for helping!! Michael "Jon Peltier" wrote: Michael - Could you instead use a series of checkboxes or dropdowns to select the plotted data? Here are some examples: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Hi Jon, It's a golf-program, that has worked very well untill I exceeded the number of data-rows allowed in Excel. In reality I only need maybe 15 rows of data. But as my original intentions worked, I haven't thought of it, before now. All my data are loaded to a sheet where I use AutoFilters via VB-script. So, if I ask for a certain golf-course or player the filter responds "live" to the request and updates graphs as well. I can't get the source data to accept a variable - or I'm not clever enough, and it has worked well, but now I may need data from row 1 and row 345, which is impossible, because of the limitations in Excel. Michael "Jon Peltier" wrote: Hi Michael - That's a lot of series for a chart. Is it going to be legible with so many lines? I've only ever seen one chart that really needed so many series; an experimental meteorologist needed custom curves on a chart (non-cartesian lines, like isobars). I was able to help him combine around a thousand of these curves into a few dozen. If you describe why you need all the series, someone might think of a similar way to reduce them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is there a work-around the 255-line limit in Excel ?? Transpose won't do the trick, as I need 22 columns of data. Excel 2000 SP3, on Win XP Pro SP2. Michael |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
more than 255 lines in chart
Hi,
The 255 is a fixed limit. You either use 2 charts overlayed with the top one having transparent chart/plot area. Obviously alignment will be an issue. Or you use 1 series with data from 2 rows and then if required change the colouration of points in the series. This would probably require a vba solution if you need any this that is suppose to be automatic. Cheers Andy SM1333 wrote: I am hoping that someone can extend this help to me. The site did not help me very much but maybe I am missing something. I have approximately 300 series that I need to put onto a chart. The reason I need this is that I have 300 separate sets of data that work out on a line graph to 300 distinct lines, and yes this is indeed visible and we can pull out the specific data lines we want to highlight. The problem is, I can't graph this as a single series because we have to use a range of columns for both the x and the y so I cannot graph more than one row at a time. Any help on how I might get more than 255 series? Thanks " wrote: Hi Jon, Looks as if it's the right track !! I have been deep in to your homepage - great stuff !! and found som links to, amongst others "J-walk", who had a work-around/dynamic chart solution using "offset" and I think that it might be possible to use the existing combo/drop-down boxes I use now. Combined with extensive use of the offset-command - I might even expand the data I/O to my graphs. Thanks for helping!! Michael "Jon Peltier" wrote: Michael - Could you instead use a series of checkboxes or dropdowns to select the plotted data? Here are some examples: http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Hi Jon, It's a golf-program, that has worked very well untill I exceeded the number of data-rows allowed in Excel. In reality I only need maybe 15 rows of data. But as my original intentions worked, I haven't thought of it, before now. All my data are loaded to a sheet where I use AutoFilters via VB-script. So, if I ask for a certain golf-course or player the filter responds "live" to the request and updates graphs as well. I can't get the source data to accept a variable - or I'm not clever enough, and it has worked well, but now I may need data from row 1 and row 345, which is impossible, because of the limitations in Excel. Michael "Jon Peltier" wrote: Hi Michael - That's a lot of series for a chart. Is it going to be legible with so many lines? I've only ever seen one chart that really needed so many series; an experimental meteorologist needed custom curves on a chart (non-cartesian lines, like isobars). I was able to help him combine around a thousand of these curves into a few dozen. If you describe why you need all the series, someone might think of a similar way to reduce them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Is there a work-around the 255-line limit in Excel ?? Transpose won't do the trick, as I need 22 columns of data. Excel 2000 SP3, on Win XP Pro SP2. Michael -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
More than 255 lines in chart | Charts and Charting in Excel | |||
Can a line(s) be added to a stacked-clustered chart? | Charts and Charting in Excel | |||
On a combination chart how do i get 2 lines and 1 column? | Charts and Charting in Excel | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel |