Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Richie
 
Posts: n/a
Default On a combination chart how do i get 2 lines and 1 column?

When trying to design a line - column combination chart, if you you add more
than 3 series you are automatically given to column series and one line. Is
it possible to alter this to get 2 lines and one column?
  #2   Report Post  
Andrea Jones
 
Posts: n/a
Default

Why don't you just click on the series you want as a line, click on the Chart
menu and choose Chart Type and change it to a line? You could also make your
own user-define line-column chart type from this chart when you have the 2
lines and 1 column, use that to format your charts in future.

Andrea Jones
www.allaboutoffice.co.uk


"Richie" wrote:

When trying to design a line - column combination chart, if you you add more
than 3 series you are automatically given to column series and one line. Is
it possible to alter this to get 2 lines and one column?

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
How do I shade the area between two lines on a chart? Hart Charts and Charting in Excel 4 April 3rd 23 04:29 PM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 11:43 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 09:26 PM
Problem drawing lines on charts Susan Lambert Charts and Charting in Excel 7 December 13th 04 09:29 AM
= Drawing more lines in a OHLCV chart = hcova Charts and Charting in Excel 1 December 13th 04 05:57 AM


All times are GMT +1. The time now is 02:38 PM.

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

About Us

"It's about Microsoft Excel"