Back to Home PageWelcome Guest! Register | Login | Home | Contact Us | Site Map | Advertise | FAQ | Search
Canadian Desi
    Charcha


        
  Canada Immigration Forum > General > Science & Technology > Graph using Excel
Last Post | Newest Post
 
< [ 1 ] >

Graph using Excel




Need some help in Excel. I have three sets of data and need to show them in one graph. Possible? Also how to change the numbers on the x or y axis?

Here is the sample data. I want to show them in one graph so that I don't have to use 2-3 different graphs. May be the x axis be the middle column where other two have similar and smaller values.

Any tip will help.
Thanx


15 399 68
30 365 65
45 344 62
60 321 59


 
MKBLR

Senior Desi
Member since: Mar 13
Posts: 195
Location:

Post ID: 217440 23-01-15 10:43:13
Report Abuse
dimple2001
Senior Desi
Member since: Apr 04




Posts: 2873
Location: Western Hemisphere


I believe what you are looking for is a Secondary Axis. If so, your data would be as follows:

First column data is the y -axis on the left side of the chart, second column data is the x axis, and the third column of data is the y axis noted on the right side of the chart (this is the secondary axis). To do that, create a line chart with first and third column data as the series 1 and series 2. Then, follow instructions below to create the secondary axis. I am using Excel 2013


Create a combo chart with a secondary axis


When the numbers in a chart you created vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis shows the values for the associated data series. A secondary axis works well in a chart that shows a combination of column and line charts.

Combo chart with secondary axis

In Microsoft Excel 2013, you can quickly show a chart like the one above by changing your chart to a combo chart.

1.Click anywhere in the chart you want to change to a combo chart to show the Chart Tools.


Chart Tools

1.Click Design > Change Chart Type.


Type group on the Design tab

1.On the All Charts tab, choose Combo, and then pick the Clustered Column - Line on Secondary Axis chart.


Combo chart with secondary axis on All Charts tab

1.Under Choose the chart type and axis for your data series, check the Secondary Axis box for each data series you want to plot on the secondary axis, and then change their chart type to Line.


2.Make sure that all other data series are shown as Clustered Column.


To clarify what is plotted on each of the vertical axes, you can add axis titles.


Add axis titles to the vertical axes

1.Click anywhere in the chart, and then click Chart Elements Chart Elements button.


2.Check the Axis Titles box, click the arrow next to it, and then check the boxes of the axis titles you want to add.


3.In the chart, click each axis title one at a time, and then type a title that describes the data that is plotted on that axis.

-----------------------------------------------------------------
Dimple2001

 
Last edited by: dimple2001 on 23-01-15 11:50:44
Post ID: 217441 23-01-15 11:49:42
Report Abuse
Full House
Senior Desi
Member since: Oct 12




Posts: 2628
Location:

USING EXCEL TO PLOT DATA...
Quote:
Originally posted by MKBLR

Need some help in Excel. I have three sets of data and need to show them in one graph. Possible? Also how to change the numbers on the x or y axis?

Here is the sample data. I want to show them in one graph so that I don't have to use 2-3 different graphs. May be the x axis be the middle column where other two have similar and smaller values.

Any tip will help.
Thanx


15 399 68
30 365 65
45 344 62
60 321 59



------------

The data 15, 30, 45, and 60 etc., are spaced evenly, which will provide you with an even spacing on the X-AXIS.
The other data alongside the previous numbers will provide you with a plot
on the Y-AXIS, One on the Left side and the Second one on the Y-AXIS on
the Right side of the chart. You will get to know the reasons when EXCEL
plots it for you.
You will have a chart that is similar to the one displayed below in U-Tube.

HERE YOU HAVE A SMALL WRITE UP ON SPREAD SHEET.
EXCEL SPREADSHEET..: https://office.live.com/start/Excel.aspx

ALTERNATELY..: http://www.google.ca/sheets/about/
How to draw TWO SETS of data on a X - Y CHART.

https://www.youtube.com/watch?v=_ZLfvogWX_A

WISH WE HAD KNOWN THIS BEFORE.. 20 ITEMS TODAY and many more tomorrow...
http://www.lifehack.org/articles/technology/20-excel-spreadsheet-secrets-youll-never-know-you-dont-read-this.html
Have a good one...: http://www.huffingtonpost.com/2014/07/21/man-wife-spreadsheet-sex_n_5605670.html

Hope this helps.


FH.


 
Post ID: 217445 23-01-15 17:21:36
Report Abuse
ramar2005
Senior Desi
Member since: Sep 04




Posts: 1233
Location: India.


If we type secondary axis on help box we may get info with examples.
-----------------------------------------------------------------


 
Post ID: 217447 23-01-15 20:50:46
Report Abuse
MKBLR
Senior Desi
Member since: Mar 13




Posts: 195
Location:


Thanks uuys. Much appreciated.


 
Post ID: 217484 26-01-15 07:37:28
Report Abuse
lorein0688
Junior Desi
Member since: May 19




Posts: 1
Location:


Excel is the one of the most complex application of MS Office and this is the reason Microsoft have implemented various tips and tricks to help the users to use the application easily.

Promotional post edited


 
Last edited by: Monica.admin on 23-05-19 14:33:51
Post ID: 238674 23-05-19 07:29:29
Report Abuse
< [ 1 ] >
 
Show Printable version
Send this page to a friend
Add to favorites
 


 
Web
CanadianDesi
Please Contribute!
Write an Article
Send Community News
Create Photo and Video Albums
Submit Good Pictures
List Useful Websites
Post Jobs
Submit Events
List for FREE!
Businesses
Classifieds
Social Organizations
Religious Places
Employment Agencies
Email Page
Your Email
Friend\'s Email

Advertise Contact Us Privacy Policy and Terms of Usage FAQ
Canadian Desi
© 2001 Marg eSolutions


Site designed, developed and maintained by Marg eSolutions Inc.