Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
To plot 3 series each with 90000 data in single Line or XY chart.
I have 3 series of a process data for over 90,000 instants. One series is
varying between 2,500 and 4,000 units, other series is varying between 150 and 190 units and the third series is varying between -20 to 5. I would like all 3 series to be plotted in a single chart to observe process performance. While ploting on excel 2007 Line/XY chart, self face the following difficulty. 1) Beyond 32,000, data points are not plotted. 2) Not able to have 3 different Y axis for 3 series. Can I have suitable suggestion. D R Chandran |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
To plot 3 series each with 90000 data in single Line or XY chart.
Hi,
Excel has the following limits in the charting area: Data series in one chart 255 Data points in a data series for 2-D charts 32,000 Data points in a data series for 3-D charts 4,000 Data points for all data series in one chart 256,000 You can beat the 32000 point limit for an xy scatter by defining 3 series for the 90000 points. Sort your x-axis values and plot the first 30000 as series 1 then add a second series and then a third series. You can plot on two axis by clicking on one of the series and choosing Format Series and clicking the Secondary Axis option. To do more than 2 axises you need to create a dummy axis. Jon's site has a number of examples of dummy axis: http://peltiertech.com/Excel/Charts/ If this helps, please click the Yes button Cheers, Shane Devenshire "Chandran" wrote: I have 3 series of a process data for over 90,000 instants. One series is varying between 2,500 and 4,000 units, other series is varying between 150 and 190 units and the third series is varying between -20 to 5. I would like all 3 series to be plotted in a single chart to observe process performance. While ploting on excel 2007 Line/XY chart, self face the following difficulty. 1) Beyond 32,000, data points are not plotted. 2) Not able to have 3 different Y axis for 3 series. Can I have suitable suggestion. D R Chandran |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
To plot 3 series each with 90000 data in single Line or XY chart.
He didn't like my answer to his private email, or didn't believe me.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Shane Devenshire" wrote in message ... Hi, Excel has the following limits in the charting area: Data series in one chart 255 Data points in a data series for 2-D charts 32,000 Data points in a data series for 3-D charts 4,000 Data points for all data series in one chart 256,000 You can beat the 32000 point limit for an xy scatter by defining 3 series for the 90000 points. Sort your x-axis values and plot the first 30000 as series 1 then add a second series and then a third series. You can plot on two axis by clicking on one of the series and choosing Format Series and clicking the Secondary Axis option. To do more than 2 axises you need to create a dummy axis. Jon's site has a number of examples of dummy axis: http://peltiertech.com/Excel/Charts/ If this helps, please click the Yes button Cheers, Shane Devenshire "Chandran" wrote: I have 3 series of a process data for over 90,000 instants. One series is varying between 2,500 and 4,000 units, other series is varying between 150 and 190 units and the third series is varying between -20 to 5. I would like all 3 series to be plotted in a single chart to observe process performance. While ploting on excel 2007 Line/XY chart, self face the following difficulty. 1) Beyond 32,000, data points are not plotted. 2) Not able to have 3 different Y axis for 3 series. Can I have suitable suggestion. D R Chandran |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
To plot 3 series each with 90000 data in single Line or XY cha
Hi Jon,
I suppose you told him the same things. Maybe he didn't read your email? Oh well... Cheers, Shane "Jon Peltier" wrote: He didn't like my answer to his private email, or didn't believe me. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Shane Devenshire" wrote in message ... Hi, Excel has the following limits in the charting area: Data series in one chart 255 Data points in a data series for 2-D charts 32,000 Data points in a data series for 3-D charts 4,000 Data points for all data series in one chart 256,000 You can beat the 32000 point limit for an xy scatter by defining 3 series for the 90000 points. Sort your x-axis values and plot the first 30000 as series 1 then add a second series and then a third series. You can plot on two axis by clicking on one of the series and choosing Format Series and clicking the Secondary Axis option. To do more than 2 axises you need to create a dummy axis. Jon's site has a number of examples of dummy axis: http://peltiertech.com/Excel/Charts/ If this helps, please click the Yes button Cheers, Shane Devenshire "Chandran" wrote: I have 3 series of a process data for over 90,000 instants. One series is varying between 2,500 and 4,000 units, other series is varying between 150 and 190 units and the third series is varying between -20 to 5. I would like all 3 series to be plotted in a single chart to observe process performance. While ploting on excel 2007 Line/XY chart, self face the following difficulty. 1) Beyond 32,000, data points are not plotted. 2) Not able to have 3 different Y axis for 3 series. Can I have suitable suggestion. D R Chandran |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
To plot 3 series each with 90000 data in single Line or XY cha
"Shane Devenshire" wrote in message ... Hi Jon, I suppose you told him the same things. What else is there to tell. Maybe he didn't read your email? He claims he posted to both places at the same time in a reply, though the post here is time-stamped well after my email reply. It's entirely possible he missed my reply until after posting here, and I certainly didn't mean any disrespect with my comment. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed | Charts and Charting in Excel | |||
Change chart type in single data series, Excel 2007 | Charts and Charting in Excel | |||
Have chart w/ data table - how can i control which series plot | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |