Chart/Graphing problems

pooadrid

New Member
Joined
Nov 24, 2014
Messages
14
i am working with two sets of information.

each set has 13 values for 1 person. and this is for 13 week period.

Person 1 Person 1
Dollars Volume
10 1
20 2
30 3
40 4
50 5
60 6
70 7
80 8
90 9
100 10
110 11
120 12
130 13


I am trying to get this into a graph that shows something like this attachment.

am i missing some formula to show profit and volume over time in some on liner
cc6Wmy
?

cc6Wmy
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Hi Pooadrid

Have you tried a "scatter plot with smooth lines"?
Your data won't give you a plot like the one shown because your data is linear - it'll give you a straight line.
 
Upvote 0
sorry that was just example.
what i really

am trying to accomplish
is using this information to graph this


in some sort of form of this


where there is one line for one person (the data provided). obviously the data provided shows up to 5 weeks so even if that isnt necessarily on the graph, i am sure there will be indicators some how on it showing how time has passed?
am i going about this the wrong way?
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top