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
|
|||
|
|||
A few questions please help!
Hiya I'm new to Excel and I have a few questions. I'm doing a small project and I need to have an "input area" in my spreadsheet along with a graph(see attachment "sheet 1"). How do I place an "input area"? And also I need to make a graph that only includes data for Total Income, Total Expenses, and Net Profit for each quarter(see attach. "sheet2"). How do I graph these data (Total Income, Total Expenses, and Net Profit) without including other data? I hope someone can help me. Thanks alot. +-------------------------------------------------------------------+ |Filename: sheet1.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4333 | +-------------------------------------------------------------------+ -- mjay123 ------------------------------------------------------------------------ mjay123's Profile: http://www.excelforum.com/member.php...o&userid=31327 View this thread: http://www.excelforum.com/showthread...hreadid=510136 |
#2
|
|||
|
|||
A few questions please help!
To select multiple columns of data use the Ctrl key and then go through the
Chart wizard as normal. When you are embedding a chart in Excel you can do this 2 ways, either on the existing sheet or in a new sheet, when you create the chart it will ask you. You can then resize it etc if necessary. "mjay123" wrote: Hiya I'm new to Excel and I have a few questions. I'm doing a small project and I need to have an "input area" in my spreadsheet along with a graph(see attachment "sheet 1"). How do I place an "input area"? And also I need to make a graph that only includes data for Total Income, Total Expenses, and Net Profit for each quarter(see attach. "sheet2"). How do I graph these data (Total Income, Total Expenses, and Net Profit) without including other data? I hope someone can help me. Thanks alot. +-------------------------------------------------------------------+ |Filename: sheet1.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4333 | +-------------------------------------------------------------------+ -- mjay123 ------------------------------------------------------------------------ mjay123's Profile: http://www.excelforum.com/member.php...o&userid=31327 View this thread: http://www.excelforum.com/showthread...hreadid=510136 |
#3
|
|||
|
|||
A few questions please help!
Thanks for the help. And how about the "input area"? The instruction I was given for the project stated I need this "input area". What is that and how do I place it? And also how do I change scaling for graph?(some values too small to see) -- mjay123 ------------------------------------------------------------------------ mjay123's Profile: http://www.excelforum.com/member.php...o&userid=31327 View this thread: http://www.excelforum.com/showthread...hreadid=510136 |
#4
|
|||
|
|||
A few questions please help!
What kind of instruction? School work?
-- Regards, Peo Sjoblom Portland, Oregon "mjay123" wrote in message ... Thanks for the help. And how about the "input area"? The instruction I was given for the project stated I need this "input area". What is that and how do I place it? And also how do I change scaling for graph?(some values too small to see) -- mjay123 ------------------------------------------------------------------------ mjay123's Profile: http://www.excelforum.com/member.php...o&userid=31327 View this thread: http://www.excelforum.com/showthread...hreadid=510136 |
#5
|
|||
|
|||
A few questions please help!
Yes its school work. I just need help on how to make an input area. -- mjay123 ------------------------------------------------------------------------ mjay123's Profile: http://www.excelforum.com/member.php...o&userid=31327 View this thread: http://www.excelforum.com/showthread...hreadid=510136 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | New Users | 4 | June 28th, 2004 02:58 PM |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | Formatting Long Documents | 4 | June 28th, 2004 02:57 PM |
FAQ - frequently asked questions - please read before posting - June posting unofficial | Charles Kenyon | Mailmerge | 6 | June 28th, 2004 02:57 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - May | Charles Kenyon | Mailmerge | 3 | May 24th, 2004 05:54 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - April | Charles Kenyon | Mailmerge | 0 | April 26th, 2004 03:33 PM |