A few questions please help!

  • Thread starter Thread starter mjay123
  • Start date Start date
M

mjay123

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 |
+-------------------------------------------------------------------+
 
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.
 
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)
 
Back
Top