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

P

Pardeep Mohan

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY scatter plot with more than 32000 rows in Excel 2003 0
Data points in chart incorrect 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Plotting x-y data to same physical dimension on plot 2
Format column widths from one table to a separate table on same page 1
XY scatter plot 3
xy scatter - dates off 4
Plotting a current Date Vertical Line 2

Top