ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I superimpose one chart over the other? (https://www.excelbanter.com/charts-charting-excel/40683-how-can-i-superimpose-one-chart-over-other.html)

sas1950

How can I superimpose one chart over the other?
 
I want to make two line charts and then take the line and legend from one
chart and put it in the other chart. Can this be done?

Earl Kiosterud


Perhaps you can use two series. Select both of the columns (if your series
are in columns) as well as the X data column. Use the Ctrl key as you
select if they're not adjacent. If the value ranges are different, assign
one or the other to the other Y axis (right click the line, FOrmat data
series - Axes).
--
Earl Kiosterud
www.smokeylake.com

"sas1950" wrote in message
...
I want to make two line charts and then take the line and legend from one
chart and put it in the other chart. Can this be done?





All times are GMT +1. The time now is 06:11 PM.

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