ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I plot two curves on a single XY scatter chart? (https://www.excelbanter.com/excel-programming/406057-how-do-i-plot-two-curves-single-xy-scatter-chart.html)

Puzzled

How do I plot two curves on a single XY scatter chart?
 
I have set out two blocks of data and want to plot the curves each of them
produces on the same XY scatter chart to make comparison easier. Thanks in
advance.

Jon Peltier

How do I plot two curves on a single XY scatter chart?
 
make the chart with one set of XY values. Select the second set and copy.
Select the chart, use Edit menu Paste Special, add the data as a New
Series with Category data in first row/column.

It's a best practice to use columns for your data, so the first curve would
use A and B, the second C and D, etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Puzzled" wrote in message
...
I have set out two blocks of data and want to plot the curves each of them
produces on the same XY scatter chart to make comparison easier. Thanks in
advance.





All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com