ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make the XY chart with two data series? (https://www.excelbanter.com/charts-charting-excel/25109-how-do-i-make-xy-chart-two-data-series.html)

Jen Kulak

How do I make the XY chart with two data series?
 
I am trying to make line graph where I can compare two seperate times. I
want to have one series as 2004 and one as 2005. However, I am completely
clueless on how to do it. Help!!!

Jerry W. Lewis

Use separate columns for 2004 and 2005. If they share common x values,
then select all three columns and insert a chart. Otherwise create the
chart for 2004, and then Chart|Add Data and specify the appropriate data
for 2005.

Jerry

Jen Kulak wrote:

I am trying to make line graph where I can compare two seperate times. I
want to have one series as 2004 and one as 2005. However, I am completely
clueless on how to do it. Help!!!




All times are GMT +1. The time now is 04:54 AM.

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