Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
2 questions: Using solver in Macro AND converting to Word document to print A3 | Excel Discussion (Misc queries) | |||
Finding my previous questions... | Excel Discussion (Misc queries) | |||
Questions??? | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |