Several curves in one graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to have different curves from different data sources on the same graph
Example: show as well ROI as Net Income (as 2 dependent variables) on assets (as independent variable).
 
Put assets in one column (say A1:A10)
Put ROI in B1:B10 and Net Income in C1:C10
Select A1:C10 and make a Line (colukn or bar) chart; use the required
subtype
Try it and come back with questions.
Best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


MIF-1-LDS said:
How to have different curves from different data sources on the same graph?
Example: show as well ROI as Net Income (as 2 dependent variables) on
Click to expand...
assets (as independent variable).
 
Not quite sure of where exactly you are stuck.

If the independent variable values are in column A and the dependent
values in B:C, select the range of interest and the chart of interest.
Then, if the range of values are very different (as I imagine ROI and
Net Income will be), double-click one of the plotted series and from the
Axes tab select Secondary.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Microsoft MVP -- Excel
 
Back
Top