If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart: 2 lines and a bar
I have searched here and in the help file with no luck. I see it is easy to have a graph with 2 bars and a line because it is one of the standards already set up. But I need 2 lines and a bar and I cant figure out how to do it. I'm sure it is something easy, but maybe this is a brain cramp or something. -- Kepf ------------------------------------------------------------------------ Kepf's Profile: http://www.excelforum.com/member.php...o&userid=30611 View this thread: http://www.excelforum.com/showthread...hreadid=507440 |
#2
|
|||
|
|||
Chart: 2 lines and a bar
Hi,
Create line chart based on all three sets of data. Select the line series that you want charted as a column and right click. From the popup menu choose Chart Type. Select the required Column chart. Cheers Andy Kepf wrote: I have searched here and in the help file with no luck. I see it is easy to have a graph with 2 bars and a line because it is one of the standards already set up. But I need 2 lines and a bar and I cant figure out how to do it. I'm sure it is something easy, but maybe this is a brain cramp or something. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Broken lines in a chart to display extreme values? | Metin Ă–rsel | Charts and Charting | 1 | October 4th, 2005 02:17 PM |
Grid Lines on an Area Chart | Phil Hageman | Charts and Charting | 1 | September 21st, 2005 11:53 PM |
Pie chart with 'anchored' lines to text box | TOMB | Charts and Charting | 0 | May 4th, 2005 09:14 PM |
Problem sizing charts and graphs | J Newell | Powerpoint | 6 | August 27th, 2004 02:26 AM |
Chart, lines drop to zero when no data entered | Tom | Charts and Charting | 2 | June 12th, 2004 11:46 PM |