Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a graph with 3 lines
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!!! |
#2
|
|||
|
|||
Gillian7117 wrote:
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 -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#3
|
|||
|
|||
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 :)) |
#4
|
|||
|
|||
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 "Gillian7117" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating single lines of data from a multi-column table | Excel Discussion (Misc queries) | |||
creating a directed graph from XY scatter | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
creating 2 lines within one cell | Excel Discussion (Misc queries) | |||
Formatting Graph Grid Lines | Excel Discussion (Misc queries) |