Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
Further to an earlier post, I have about 59000 data points that I want
to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
Is there any visible difference from plotting say every other value instead
of all 59000 points ? NickHK "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
NickHK wrote:
Is there any visible difference from plotting say every other value instead of all 59000 points ? NickHK "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris Thanks for your reply Nick. No, I have just been looking at that and seems as tho that is what I will have to do. To do this, will I have to extract every second point to another column and then define that as the series or is there another smart way of defining the series to take every second point? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
NickHK wrote:
Is there any visible difference from plotting say every other value instead of all 59000 points ? NickHK "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris Thanks for your reply Nick. No, I have just been looking at that and seems as tho that is what I will have to do. To do this, will I have to extract every second point to another column and then define that as the series or is there another smart way of defining the series to take every second point? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
NickHK wrote:
Is there any visible difference from plotting say every other value instead of all 59000 points ? NickHK "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris Thanks for your reply Nick. No, I have just been looking at that and seems as tho that is what I will have to do. To do this, will I have to extract every second point to another column and then define that as the series or is there another smart way of defining the series to take every second point? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
Use a scatter plot and adjust the series style to add lines.
Tim "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
Tim Williams wrote:
Use a scatter plot and adjust the series style to add lines. Tim "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris Tim I have tried that and the 32000 limit still applies. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
You can the fact that the chart will only use visible data in its plot so if
you have a Sequence column, you can apply a filter of "=MOD(A8,2)=0)" to get every other row. For that matter, you could maybe get away with every 10th row for a faster display. Depends on your data and requirements. Not sure how your situation would work, where you have too many points to start with. NickHK "inquirer" wrote in message ... NickHK wrote: Is there any visible difference from plotting say every other value instead of all 59000 points ? NickHK "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris Thanks for your reply Nick. No, I have just been looking at that and seems as tho that is what I will have to do. To do this, will I have to extract every second point to another column and then define that as the series or is there another smart way of defining the series to take every second point? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
Hi,
Here is a way without using a helper column. http://tushar-mehta.com/excel/newsgr...ers/index.html Cheers Andy inquirer wrote: NickHK wrote: Is there any visible difference from plotting say every other value instead of all 59000 points ? NickHK "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris Thanks for your reply Nick. No, I have just been looking at that and seems as tho that is what I will have to do. To do this, will I have to extract every second point to another column and then define that as the series or is there another smart way of defining the series to take every second point? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
If you don't mind a pair of helper columns try this -
Sample XY data: A2=0 B2=0 A3=1 B3=B2+0.1 Select A2:B3 and drag the little handle down to say 10002 F1=100 ' every n'th plot helper columns: C2 =OFFSET($A$2,(ROW(C2)-ROW($A$2))*$F$1,0) D2 =OFFSET($B$2,(ROW(D2)-ROW($B$2))*$F$1,0) Copy C2:D2 down to say 1002+, enough for every 10th point (later you'll need more for your 59k) With F1=100 then D103 & below will = 0, doesn't matter how many of these but maintain at least as many as will ever be needed. Define these names, Ctr-F3 Name: CatX =OFFSET($C$2,0,0,COUNTA($B$2:$B$65535)/$F$1+1,1) Name: Ser1 =OFFSET($D$2,0,0,COUNTA($B$2:$B$65535)/$F$1+1,1) Make a chart: Select a couple of cells containing numbers surrounded by blanks With the chart wizard choose say Line without markers and go straight to Finish Select the dummy two point series In the Edit bar replace the formula =SERIES(,MyBook.xls!CatX,MyBook.xls!Ser1,1) You may need to bracket 'MyBook.xls' with apostrophes if any non-standard characters exist in the xls name (eg space). Hopefully your Series is now as anticipated. Change the value in F1 to suit. How much you can increase it (every n'th) might depend on how spiky your chart is. Regards, Peter T "inquirer" wrote in message u... Further to an earlier post, I have about 59000 data points that I want to plot on an line chart. The points for the x axis are sorted in ascending order. I can plot the first 32000 points ok as Series 1 but how can I then plot points from 32001 on so they plot on the end of series 1? I have treid defining series 2 as 32001 onwards but these points do not plot on the end of series 1, rather they start again at the origin. Any help much appreciated Thanks Chris |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plotting more than 32000 points on a chart
.... but you *can* use 1 series
Tim -- Tim Williams Palo Alto, CA "inquirer" wrote in message u... Tim Williams wrote: Use a scatter plot and adjust the series style to add lines. Tim "inquirer" wrote in message Tim I have tried that and the 32000 limit still applies. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting NA() or #N/A data points | Charts and Charting in Excel | |||
XY Charts - not plotting zero or #N/A Points | Charts and Charting in Excel | |||
Not plotting data points in a line chart | Charts and Charting in Excel | |||
Plotting two data points as one | Excel Discussion (Misc queries) | |||
Excel 2003 xy chart - problem plotting more than 330 points | Charts and Charting in Excel |