Creating a graph with 3 lines

G

Gillian7117

Hello, hope you can help.
I am trying to do a break-even analysis in the form of a graph. I am
extreamly stuck on what to do
Ive searched help and it gives me the option of downloading a wrksheet to
input all the details but that is not what i am wanting. I just want to enter
the details in excel as I already know the amounts and then to be presented
with a simple graph with 3 entries.
What do I search under to help me input 3 sources of information in like the
fixed costs, selling costs and variable costs?
Im realy stuck!!!
 
G

Gordon

Gillian7117 said:
Hello, hope you can help.
I am trying to do a break-even analysis in the form of a graph. I am
extreamly stuck on what to do
Ive searched help and it gives me the option of downloading a wrksheet to
input all the details but that is not what i am wanting. I just want to enter
the details in excel as I already know the amounts and then to be presented
with a simple graph with 3 entries.
What do I search under to help me input 3 sources of information in like the
fixed costs, selling costs and variable costs?
Im realy stuck!!!

Select the area of your data (including titles and months etc)and then
click on the chart icon. Follow the instructions
 
C

Chris Rogers

Gillian,

It sounds like you are trying to do a stacked graph with 3 types of
data - you'll want to pay attention to the data series for the graph
and play around with it - sometimes it doesn't come out the way you
expect (at least for me anyway :))
 
G

Gillian7117

Hello, It was alot lot easier than what I thought. i just did 3 sets of
information and I did it, i think what was stressing me out was where I put
the axas name, but then realised you add them in after!!
Thanks for your help xx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top