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
|
|||
|
|||
Graphing Question
I'm trying to graph a 2005 company trend showing dollars and numbers. The dollar amount is in the millions and the number amount is in the low 100's. How can I graph both lines on the same chart? When I try to graph them as separate series the number trend basiclly lies on top of the x axis. I'd like to be able to see both of them on the same graph. -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=506802 |
#2
|
|||
|
|||
Graphing Question
Hi,
Plot one of the lines on the secondary Y axis. To do this double click one of the series and on the Axis tab of the Format Dialog choose secondary axis. Cheers Andy petevang wrote: I'm trying to graph a 2005 company trend showing dollars and numbers. The dollar amount is in the millions and the number amount is in the low 100's. How can I graph both lines on the same chart? When I try to graph them as separate series the number trend basiclly lies on top of the x axis. I'd like to be able to see both of them on the same graph. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Graphing Question
Thanks so much for your help Andy. It looks great!!! -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=506802 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
random sort my table | ADAM | Running & Setting Up Queries | 5 | December 30th, 2005 07:59 AM |
graphing question - want to show total in datatable only | Ben | Setting Up & Running Reports | 1 | December 1st, 2005 05:23 PM |
Question about reducing number of tables in a database | tlyczko | Database Design | 0 | October 27th, 2005 04:15 PM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |
Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |