I have three sets of data in which I am trying to graph. I have three sets time data and one set of distance data. I am trying to plot my distance on the Y-axis, however, excel automatically puts this on the x-axis. How do I switch them?
Jennifer
Hello,
charting depends heavily on the data layout in the source table. Without seeing what you have in place, it's hard to advise. Post a data sample in an Excel file.
You may want to look at XY charts.
Assuming you have data in columns in order T1, T2, T3, and D.
Select T1 data, hold Ctrl and select D data (two ranges highighted). Create your XY chart.
Select T2 data, hold Ctrl and select D data (two ranges highighted). Copy, then select chart, and use Paste Special to add data as new series.
Select T3 and D data (one two-column range highlighted). Copy, then select chart, and use Paste Special to add data as new series.
Jon Peltier
http://PeltierTech.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks