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
|
|||
|
|||
Charts and Line Graphs comparing companies with different data
I am trying to create a chart that is a line graph in Excel 2000. I want to
compare severao builders price and square feet with each company being a different color. Here is an example Company A has homes that are 2152 square feet at $162000, 2424 square feet at $169000, and 2691 square feet at $178000. Company B has homes that are 2095 square feet at $159000, 2292 square feet at $164000, and 2436 square feet at $173000. There will probably be Companys c thru H as well with different data. Can you help? I have searched the web and all this is greek to me - I need it to be in the simplest terms possible please! Thank you! |
#2
|
|||
|
|||
Charts and Line Graphs comparing companies with different data
Put company A's data into columns A and B like this:
Company A 2152 162000 2424 169000 2691 178000 The top left cell in this region should be blank. Select this rectangular data range, including the blank cell and "Company A" label at the top, and use the chart wizard to create an XY chart of this data, using markers with lines. Each additional company's data should be arranged the same way. It's probably best to put Company B into columns C and D, Company C into columns E and F, etc. To add another company's data to the chart, select and copy the data, including the blank cell and "Company X" label at the top. Select the chart, and use Paste Special from the Edit menu to add the data as a new series, categories in first column, series name in first row. Repeat as needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Joyous412" wrote in message ... I am trying to create a chart that is a line graph in Excel 2000. I want to compare severao builders price and square feet with each company being a different color. Here is an example Company A has homes that are 2152 square feet at $162000, 2424 square feet at $169000, and 2691 square feet at $178000. Company B has homes that are 2095 square feet at $159000, 2292 square feet at $164000, and 2436 square feet at $173000. There will probably be Companys c thru H as well with different data. Can you help? I have searched the web and all this is greek to me - I need it to be in the simplest terms possible please! Thank you! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PowerPoint data charts switching? | Niki | Powerpoint | 1 | October 5th, 2005 03:10 PM |
Charts Line Types for Multiple Data Series not Printing Properly | Seanb | Charts and Charting | 0 | August 22nd, 2005 06:35 PM |
Charts which automatically adapt to variable source data length | Excel Engineer | Charts and Charting | 1 | August 15th, 2004 12:47 PM |
lines between data points | Steven M | Charts and Charting | 1 | December 16th, 2003 03:48 PM |
Line Charts with 3 sets of data? | J. Stacey | Charts and Charting | 3 | September 18th, 2003 01:57 AM |