How to make xy plot of date format data in both columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I plot the data in two columns if the data in both of these is in the
data format? I tried doing it but I ended up getting two different series
instead of one.
Pardeep Mohan
 
Hi,

Quickest way is to add a column heading to the second (Y) column of
values. The the chart wizard will read the 1st column as X values and
the 2nd as Y.

Otherwise use the Source Data dialog and specify the correct ranges for
the 1st series and delete the 2nd.

Cheers
Andy
 
Back
Top