Computer Tech, Gaming & Electronics THIS SPACE OPEN FOR ADVERTISEMENT. YOU SHOULD BE ADVERTISING HERE!
Silicon Valley.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news... |
 | 
08-02-2011, 10:09 AM
|
#1 | | RS.net, helping ugly ppl have sex since 2001
Join Date: Sep 2008 Location: Vancouver
Posts: 8,858
Thanked 2,420 Times in 669 Posts
Failed 530 Times in 136 Posts
| Excel Gurus I need help
I'm planning to create a chart in excel 07 for cost analysis of 10 items for school. Cost on Y-Axis and Time on X-Axis. So the chart will be Cost vs Time.
Its not very neat to the eye to have all 10 items on the same chart. So, what I was thinking to do was create individual charts for the items. This I know how to do.
Then create one blank chart, with two drop down list, that can bring up any
two individual charts so I can compare the chosen two charts overlaid on top of each other.
Any one know how to do this?
__________________
2014 Honda Civic Si
Last edited by shenmecar; 08-02-2011 at 10:24 AM.
| 
|  | |
08-02-2011, 04:33 PM
|
#2 | | Willing to sell body for a few minutes on RS
Join Date: Aug 2004 Location: Duncan, BC
Posts: 10,128
Thanked 5,568 Times in 2,107 Posts
Failed 231 Times in 90 Posts
|
Should be pretty simple with PivotCharts ...
Column A = Item Name
Column B = Price
Column C = Date
Highlight A1 to C? (end of table), select Format as Table (colour scheme doesn't matter, just choose whatever looks best to you).
Once you've formatted it as a table, Insert > PivotTable > PivotChart
On the right, put Item in Legends Fields, Date in Axis Fields, and Price in Values.
Right-Click on any empty space in the Chart, then select Change Chart Type, select a line graph.
On the right side of the chart, you'll see a grey box with Item and a down arrow next to it. If you click on that, you can select which items you would like to have displayed ...
See attachments for visuals ...
Last edited by Jmac; 08-02-2011 at 04:46 PM.
| |
| | |
08-03-2011, 03:33 PM
|
#3 | | Willing to sell body for a few minutes on RS
Join Date: Aug 2004 Location: Duncan, BC
Posts: 10,128
Thanked 5,568 Times in 2,107 Posts
Failed 231 Times in 90 Posts
| | |
| | |
08-03-2011, 03:50 PM
|
#4 | | :inoutugh:
Join Date: Feb 2008 Location: GTA VI
Posts: 10,011
Thanked 5,864 Times in 1,851 Posts
Failed 970 Times in 279 Posts
| Quote:
Originally Posted by Jmac  | There, there, brother.  | |
| | |
08-03-2011, 08:53 PM
|
#5 | | I Will not Admit my Addiction to RS
Join Date: Jun 2002 Location: Vancouver->HK
Posts: 560
Thanked 188 Times in 41 Posts
Failed 38 Times in 11 Posts
| Quote:
Originally Posted by Jmac | lol i used to know this stuff...i think
| |
| | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | |
All times are GMT -8. The time now is 02:28 PM.
|
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
