Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 8th 06, 05:37 PM posted to microsoft.public.excel.newusers
mjay123
 
Posts: n/a
Default 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   Report Post  
Old February 8th 06, 06:25 PM posted to microsoft.public.excel.newusers
sp3cialist
 
Posts: n/a
Default 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   Report Post  
Old February 8th 06, 07:17 PM posted to microsoft.public.excel.newusers
mjay123
 
Posts: n/a
Default 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   Report Post  
Old February 8th 06, 07:43 PM posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default 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   Report Post  
Old February 8th 06, 08:04 PM posted to microsoft.public.excel.newusers
mjay123
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - how can I practice formulas on financial questions? flamingformulas Excel Discussion (Misc queries) 4 February 20th 06 03:18 PM
2 questions: Using solver in Macro AND converting to Word document to print A3 yendor28 Excel Discussion (Misc queries) 3 November 17th 05 07:55 PM
Finding my previous questions... cdavidson Excel Discussion (Misc queries) 2 November 17th 05 06:12 PM
Questions??? Metalteck Excel Discussion (Misc queries) 2 May 24th 05 08:18 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017