ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-03-2005, 01:06 PM
Jackie
Guest
 
Posts: n/a
How do I plot both line and column data on same graph?

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!!
Reply With Quote
  #2  
Old 05-03-2005, 02:06 PM
John Mansfield
Guest
 
Posts: n/a
RE: How do I plot both line and column data on same graph?

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

--
Regards,
John Mansfield
http://www.pdbook.com


"Jackie" wrote:

> 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!!

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 10:55 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0