Skip to main content

Graph: Ms Excel 2010

To plot a graph in Microsoft Excel 2010 by taking the column data as axis in the graph:
1.Highlight the column data that you wish to plot.
2.Insert-> scatter graph

If you wish to plot a chart of X1 and X2 against Y
X2 X1 Y
88 123 100
188 234 200
350 345 300
500 456 400
Select these columns, goto insert and then click scatter chart. This will give the following chart:


But this is not what we want. Now plot X2 and Y , then plot X1 and Y. Then copy the curve from a plot and paste the curve to another plot.


If you wish to edit the style of the plot. For e.g. changing the thickness of the graph line:
1. Right click on the graph -> format data series -> line style -> width (you can specify the thickness value here)

If you wish to scale the range of x-axis and y-axis data values:
1. Double click on th ex-axis -> axis options -> set the minimum/maximum values ( you can also change other values as you need)

If you wish to label some data points:
1. Double click on the curve -> add data label at specific points

If you wish to provide label for the x-axis and y-axis:
1. click on the graph -> Layout -> AxisTitle -> Primary Horizontal/Vertical Axis Title -> write your title
2.similar process for giving chart name as well.
Labels:

Comments

Post a Comment

Popular posts from this blog

Python : split any file (binary) to different pieces and join them

This python program takes an input file and then splits it into different smaller chunks. Next it can collect all the different chunks and join it to get the original file. -------------------------------------------------------- # define the function to split the file into smaller chunks def splitFile(inputFile,chunkSize): #read the contents of the file f = open(inputFile, 'rb') data = f.read() # read the entire content of the file f.close() # get the length of data, ie size of the input file in bytes bytes = len(data) #calculate the number of chunks to be created noOfChunks= bytes/chunkSize if(bytes%chunkSize): noOfChunks+=1 #create a info.txt file for writing metadata f = open('info.txt', 'w') f.write(inputFile+','+'chunk,'+str(noOfChunks)+','+str(chunkSize)) f.close() chunkNames = [] for i in range(0, bytes+1, chunkSize): fn1 = "chunk%s...
2 comments
Read more

Installing NS-3 in Ubuntu

Installing testing it and running NS-3 in Ubuntu 10.04 NS-3 is a discrete-event network simulator basically for simulating Internet systems. #The list of Dependency for ns 3.12(sorry if something is missing): sudo apt-get install gcc g++ python sudo apt-get install gcc g++ python python-dev sudo apt-get install mercurial sudo apt-get install bzr sudo apt-get install gdb valgrind sudo apt-get install gsl-bin libgsl0-dev libgsl0ldbl sudo apt-get install flex bison sudo apt-get install g++-3.4 gcc-3.4 sudo apt-get install tcpdump sudo apt-get install sqlite sqlite3 libsqlite3-dev sudo apt-get install libxml2 libxml2-dev sudo apt-get install libgtk2.0-0 libgtk2.0-dev sudo apt-get install libgtk2.0-0 libgtk2.0-dev sudo apt-get install vtun lxc sudo apt-get install uncrustify sudo apt-get install doxygen graphviz imagemagick sudo apt-get install texlive texlive-pdf texlive-latex-extra texlive-generic-extra texlive-generic-recommended sudo apt-get install python-sphinx dia t...
6 comments
Read more

Display dynamic content in Google Earth using KML

Keyhole Markup Language (KML) is a xml standard which can be used to define what and how to present geographic data in Google Earth and Google Maps. Useful examples to start can be browsed via https://developers.google.com/kml/documentation/kml_tut . I have to display KML data in googleearth. And the KML file has to be loaded dynamically and the updates in the kml file should be shown in the googleearth on the fly. For this we have to Create a Network Link. Goto Add -> Network Link Then specify the details as shown in the figure. To specify the frequency of updating the data, go to Refresh tab. The code for dynamicKML.kml is as follows: junk.kml onInterval 5 Note that, we are using a local file junk.kml   ( junk.kml and dynamciKML.kml reside in the same directory) to define the content to be displayed in the google earth interface. This can even be a remote file in which case we have t...
Post a Comment
Read more