Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Robert
 
Posts: n/a
Default How to create chart with columns and 2 lines?

Excel will let me create a combination chart with two sets of columns and one
line. I'd like one set of columns and two lines. Can I get it to convert
the second data series from columns to line points?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How to create chart with columns and 2 lines?

Hi,

Just create a standard line chart and the select the series you want to
plot as columns. Right click and choose Chart Types. Select the required
line chart.

Cheers
Andy

Robert wrote:
Excel will let me create a combination chart with two sets of columns and one
line. I'd like one set of columns and two lines. Can I get it to convert
the second data series from columns to line points?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter chart with columns instead of points Bill_S Charts and Charting in Excel 1 October 7th 05 04:52 AM
Excel-rolling data linked to chart & worksheet columns must stay JJ Charts and Charting in Excel 0 September 14th 05 10:15 PM
Trying to create a page with three columns [email protected] Excel Discussion (Misc queries) 2 April 2nd 05 03:27 PM
How Do I create a spreadsheet with a finite set of columns and ro. walt093 New Users to Excel 1 February 8th 05 08:37 PM
Creating a chart with values from two columns Ivan Charts and Charting in Excel 2 December 12th 04 07:31 PM


All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"