How do I plot both line and column data on same graph?

J

Jackie

I have 5 series of data that need to be plotted. The x-axis is the same for
all, however I need the first series in column form and the remaining 4 in
line form. Can anyone tell me how to do this? Thanks!!
 
J

John Mansfield

Jackie,

Click once on the column that you want to be a line
Right-click on your mouse
Select Chart-type from the menu
In the Chart-type dialog box -> Standard Types tab - select line
Hit the OK button
 

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

Plotting Graph with dynamic table 3
Use text descriptors as Y axis units 1
XY scatter plot with more than 32000 rows in Excel 2003 0
adding trendline to plots from multiple series 1
Data points in chart incorrect 0
X-Axis Appearing in Plot Area 2
Plotting against Date (collating months) 2
x-y scatter plots and trend lines 0

Top