Excel help! How to create legend title? - YotaTech Forums
YotaTech Forums  

Go Back   YotaTech Forums > Toyota Forums Available > Electronics > Computer Talk

Notices

Welcome to Yotatech!
Welcome to Yotatech,

You are currently viewing our forum as a guest, which gives you limited access to view most discussions and access our other features. By joining our community, at no cost, 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 free, fast and simple, so please join our community today!


Reply
 
Thread Tools Search this Thread
Old 03-23-2006, 01:57 PM   #1 (permalink)
Contributing Member
 
DH6twinotter's Avatar
 
Join Date: Oct 2002
Location: Charlotte, North Carolina
Posts: 1,676
Excel help! How to create legend title?

Hey all,

I've got a Legend for a chart I created in Excel. I'm suppose to add a title to the legend, but I can't figure it out for the life of me. Is this even possible? None of the examples in the book I'm using have a title in the legend. I've spent at least 2 hours just trying to get this and gave up.

Thanks!
Daniel
This ad is not displayed to registered members.
Register your free account today and become a member on Yotatech!
__________________
------------------------------------------------
1990 4Runner: SR5, 2wd, 3.90 rear, 3VZ-E, auto.
15x8 MT classic II rims, 31x10.50 Bridgestone Desert Duellers ($50!), Cobra CB, 3' firestick
Planned stuff: Pre-runner light bar with Hella 500s, small lift
Stuff I'd do if I went crazy: SAS, 7mgte or 1UZ swap, and as much offroad goodies as $$ will allow.
DH6twinotter is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 01:58 PM   #2 (permalink)
Banned
 
Join Date: Mar 2004
Posts: 0
Send a message via AIM to Localmotion
you should be able to right click on the chart and insert a title and legend

It is under chart options.

Last edited by Localmotion; 03-23-2006 at 02:00 PM.
Localmotion is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 02:04 PM   #3 (permalink)
Contributing Member
 
DH6twinotter's Avatar
 
Join Date: Oct 2002
Location: Charlotte, North Carolina
Posts: 1,676
Thanks, I have a chart title and a legend showing, but I'm suppose to have a title in the legend itself.
__________________
------------------------------------------------
1990 4Runner: SR5, 2wd, 3.90 rear, 3VZ-E, auto.
15x8 MT classic II rims, 31x10.50 Bridgestone Desert Duellers ($50!), Cobra CB, 3' firestick
Planned stuff: Pre-runner light bar with Hella 500s, small lift
Stuff I'd do if I went crazy: SAS, 7mgte or 1UZ swap, and as much offroad goodies as $$ will allow.
DH6twinotter is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 02:15 PM   #4 (permalink)
Contributing Member
 
DH6twinotter's Avatar
 
Join Date: Oct 2002
Location: Charlotte, North Carolina
Posts: 1,676
Here's a screen shot of what I have:



Sorry its small. The title needs to go inside the legend box below the chart.

Thanks!
__________________
------------------------------------------------
1990 4Runner: SR5, 2wd, 3.90 rear, 3VZ-E, auto.
15x8 MT classic II rims, 31x10.50 Bridgestone Desert Duellers ($50!), Cobra CB, 3' firestick
Planned stuff: Pre-runner light bar with Hella 500s, small lift
Stuff I'd do if I went crazy: SAS, 7mgte or 1UZ swap, and as much offroad goodies as $$ will allow.

Last edited by DH6twinotter; 03-23-2006 at 02:17 PM.
DH6twinotter is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 08:54 PM   #5 (permalink)
Contributing Member
 
DH6twinotter's Avatar
 
Join Date: Oct 2002
Location: Charlotte, North Carolina
Posts: 1,676
Thanks for the help localmotion. I went ahead and submitted the assignment. I never did figure out how to add the title to the legend, but oh well. I've got almost a perfect score in the class, so it's not terribly important. We'll see how it goes.

Thanks!
Daniel
__________________
------------------------------------------------
1990 4Runner: SR5, 2wd, 3.90 rear, 3VZ-E, auto.
15x8 MT classic II rims, 31x10.50 Bridgestone Desert Duellers ($50!), Cobra CB, 3' firestick
Planned stuff: Pre-runner light bar with Hella 500s, small lift
Stuff I'd do if I went crazy: SAS, 7mgte or 1UZ swap, and as much offroad goodies as $$ will allow.
DH6twinotter is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 08:55 PM   #6 (permalink)
Banned
 
Join Date: Mar 2004
Posts: 0
Send a message via AIM to Localmotion
oh crap..i forgot about that!


I think you have to do it under source data?

Sorry I dont remember

Last edited by Localmotion; 03-23-2006 at 08:57 PM.
Localmotion is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 09:08 PM   #7 (permalink)
Contributing Member
 
DH6twinotter's Avatar
 
Join Date: Oct 2002
Location: Charlotte, North Carolina
Posts: 1,676
lol, it's all good.

Thanks!
__________________
------------------------------------------------
1990 4Runner: SR5, 2wd, 3.90 rear, 3VZ-E, auto.
15x8 MT classic II rims, 31x10.50 Bridgestone Desert Duellers ($50!), Cobra CB, 3' firestick
Planned stuff: Pre-runner light bar with Hella 500s, small lift
Stuff I'd do if I went crazy: SAS, 7mgte or 1UZ swap, and as much offroad goodies as $$ will allow.
DH6twinotter is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-23-2006, 10:24 PM   #8 (permalink)
Contributing Member
 
marko3xl3's Avatar
 
Join Date: Jun 2005
Location: San Jose, CA
Posts: 1,709
Send a message via AIM to marko3xl3
You can always add a custom textbox
__________________
:Marko:
Supercharged 98 4Runner SR5 4x4 3.4L
4" Deckplate :: TrueFlow Air Intake System :: Magnaflow 18" Muffler w/ Resonator
XM Satellite Radio (Roady 2)
:: Autometer Boost Gauge :: Color Keyed Spoiler


TOYOTA|moving forward
marko3xl3 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
2007, add, change, chart, chartingchartlegendtitle, code, color, create, creating, excel, insert, legend, legendtitle, title, vba

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with Word/Excel Plzz Stive2699 Off Topic Talk 2 01-13-2007 05:14 PM
I now own the Legend. dave1993 86-95 Trucks & 4Runners 29 09-28-2006 07:47 PM
need help with simple excel workings. bflooks Computer Talk 3 11-15-2005 04:15 AM
Hye Excel experts... jacksonpt Computer Talk 3 06-13-2005 06:21 AM
Fina excel??? smiljko Maintenance & Repair Archives 0 11-03-2004 04:55 AM


All times are GMT -8. The time now is 10:05 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by vbWiki Pro . Copyright ©2006, NuHit, LLC
2009 InternetBrands, Inc.