Go Back   Computer Forums > Welcome To Computer Forums .org > Social Lounge | Off Topic
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 01-04-2007, 07:49 PM   #1
Fully Optimized
 
^Mike^'s Avatar
 
Join Date: Oct 2005
Posts: 2,958
Send a message via ICQ to ^Mike^ Send a message via AIM to ^Mike^ Send a message via MSN to ^Mike^ Send a message via Yahoo to ^Mike^
Default Excel Spreedsheet Graph Help!!!

My dad asked me to do a bar graph for his company and it is planned to look something like this:
http://www.originlab.com/www/product...=44&s=8&lm=215
you see how some bars are just blue and others are a combination of blue, green , and red. The way he wants it is just a 2 color bar instead of 3 colored.

I don't know how to do the 2 color bars? Can anyone help me with setting it up?
On the bottom of the graph is "Years" 2001-2007, on the side is "Dollars in Millions" and it must go up to 30.
__________________

^Mike^ is offline   Reply With Quote
Old 01-04-2007, 08:08 PM   #2
Daemon Poster
 
Illmatic's Avatar
 
Join Date: Nov 2006
Posts: 941
Send a message via AIM to Illmatic
Default Re: Excel Spreedsheet Graph Help!!!

When you make the chart, press column, then under the column subtypes select the 3-color stacked one.

Edit: Also, I think the data has to be under seperate columns when you select it for excel to recognize it.
If you need me to make it for you I can.
__________________

__________________
My word is bond and bond is life and I will give my life before my word shall fail.
Illmatic is offline   Reply With Quote
Old 01-04-2007, 08:10 PM   #3
Fully Optimized
 
^Mike^'s Avatar
 
Join Date: Oct 2005
Posts: 2,958
Send a message via ICQ to ^Mike^ Send a message via AIM to ^Mike^ Send a message via MSN to ^Mike^ Send a message via Yahoo to ^Mike^
Default Re: Excel Spreedsheet Graph Help!!!

Well the problem is I don't know how to make a 2-color stacked chart
^Mike^ is offline   Reply With Quote
Old 01-04-2007, 08:21 PM   #4
Daemon Poster
 
Illmatic's Avatar
 
Join Date: Nov 2006
Posts: 941
Send a message via AIM to Illmatic
Default Re: Excel Spreedsheet Graph Help!!!

Yeah, Like this?
__________________
My word is bond and bond is life and I will give my life before my word shall fail.
Illmatic is offline   Reply With Quote
Old 01-04-2007, 08:24 PM   #5
Fully Optimized
 
^Mike^'s Avatar
 
Join Date: Oct 2005
Posts: 2,958
Send a message via ICQ to ^Mike^ Send a message via AIM to ^Mike^ Send a message via MSN to ^Mike^ Send a message via Yahoo to ^Mike^
Default Re: Excel Spreedsheet Graph Help!!!

Quote:
Originally Posted by AlexF1224
Yeah, Like this?
YES! exactly can you send me the excel file? Michael.Lugar@gmail.com
^Mike^ is offline   Reply With Quote
Old 01-04-2007, 08:28 PM   #6
Daemon Poster
 
Illmatic's Avatar
 
Join Date: Nov 2006
Posts: 941
Send a message via AIM to Illmatic
Default Re: Excel Spreedsheet Graph Help!!!

sent.
__________________
My word is bond and bond is life and I will give my life before my word shall fail.
Illmatic is offline   Reply With Quote
Old 01-04-2007, 08:30 PM   #7
Fully Optimized
 
^Mike^'s Avatar
 
Join Date: Oct 2005
Posts: 2,958
Send a message via ICQ to ^Mike^ Send a message via AIM to ^Mike^ Send a message via MSN to ^Mike^ Send a message via Yahoo to ^Mike^
Default Re: Excel Spreedsheet Graph Help!!!

Quote:
Originally Posted by AlexF1224
sent.
THANKS SO MUCH

+ Rep
__________________

^Mike^ is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 02:03 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0