ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   A few questions please help! (https://www.excelbanter.com/new-users-excel/70321-few-questions-please-help.html)

mjay123

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


sp3cialist

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



mjay123

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


Peo Sjoblom

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



mjay123

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



All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com