A graph is a diagram representing a relationship, system or connection between two or more points or sets of data.

learn more… | top users | synonyms (1)

1
vote
2answers
633 views

Excel 2010 column graph round percentage values to over than 100%

I have a graph showing percentages with a Data Table alongside. Excel 2010 rounds the values so that columns can sum to more than 100%, but I want every column in the graph to total exactly 100%. ...
1
vote
2answers
259 views

All cells in column as graph source except header

I want to create a graph of all values in a column, except the first which is a header. I could do this by selecting the following as Series X Values: =Foo!$A$2:$A$8 Problem is that I'd have to ...
1
vote
2answers
353 views

Graphing connections per second in excel

I have an excel file like so: date time connections 2010-10-18 08:20:00 38 2010-10-18 08:20:01 71 2010-10-18 08:20:02 67 I want a line graph with the number of connections as the y axis ...
0
votes
2answers
32 views

Having some issues making specific line charts in Excel

I am sorry if this is a dumb question, but I need to pass a graph to excel and I'm failing to do so. I have no idea where to fix it. Basically I already have one on Matlab, but I want to remake it ...
0
votes
2answers
317 views

Excel 2010 line chart; limiting data points to fewer than the max

In Excel 2010, how do I limit the number of data points on a line graph to the latest (or last) 4 data? I update the spreadsheet often, but only the latest data is graphed and reported.
0
votes
2answers
90 views

Is there a tool that can let me visualise timestamps by day/week/month?

On our website we record thousands of events in tables each with a unique timestamp. Is there a tool that can plot for me the number of timestamps that fall within a day, week, or month, on a graph ...
3
votes
1answer
2k views

Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...
3
votes
1answer
192 views

Labelling points in a plot in Excel with customized label

I want to label a plot's points in excel with neither the x nor the y variable but a label that is in a cell where the row happens to be. So for example, if I have the following table data: 1 1 a ...
2
votes
1answer
333 views

Constructing an annual cycle/radial diagram in PowerPoint

I would like to make a diagram like the below in PowerPoint, but I can't figure out how to draw the curved boxes (like the ones that say "Fishing" or "Trapping" in the chart). Diagram ...
2
votes
1answer
1k views

Application to generate graphs from MySQL table

I am looking for a solution to generate graphs from MySQL tables (local MySQL server). I would like it to work on Windows, and not be based on a server (like a PHP server). This is just basic stuff: ...
1
vote
1answer
810 views

How to plot 3D graphs in Excel from CSV data?

I have data formatted like this in a csv file: a, 1, 4, 6.0 a, 2, 42, 16.0 a, 5, 14, 69.3 a, 11, 4, 7.0 b, 1, 45, 6.0 b, 2, 45, 1.9 b, 9, 2, 4.4 b, 11, 4, 7.9 lines with first parameter a is one ...
1
vote
1answer
808 views

Excel graph: turn stacked bar chart into part bullet chart

I've a simple data file that has one column of actuals and another of target against categories. I would like to turn the TARGET figure into a 'Bullet marker'. I've seen it done on other graphs but ...
0
votes
1answer
20 views

In microsoft excel 2013, how do you find where a data point would intersect with an already plotted lineÉ

So I have a graph with one series of data, with a trend line and an associated trend line equation (y = mx + b). I have another series of data, but only of y-values. I want to find the x-values of ...
0
votes
1answer
38 views

Excel graph showing customer representation based on size of different businesses

I would like to represent in a graph the percentage of A, B and C customers in each business unit, taking into account the size of the BU (on the X axis). Sales % A % B % C ...
0
votes
1answer
76 views

Calculating Range coverage

I'm putting together a sheet that includes two data columns, 'Min Value' and 'Max Value'. All values between Min and Max values are consider the 'Range' of each entry. The goal of the sheet is to ...
0
votes
1answer
1k views

Excel scatter graph fill inside shape

I would like to fill the area between two graphs. My data is in the following format: x y 0 0 1 1 2 4 .... 0 0 As you can see they start and end at the same point. For my data it draws a chart ...
0
votes
1answer
76 views

Display and analyze the graph of a website to check its connectivity and compute properties

I would like to check several properties of the graph behind a website I own. The properties I'm interested in are: diameter, shortest path from index page, min/max/average degree of vertices, and ...
0
votes
1answer
235 views

Radial Density Plots

I am interested in making plots similar to those attached. Any recommendations on what software (or python code) to use? I suppose there are two things I would like it to do (although either one alone ...
0
votes
1answer
103 views

Creating a graph for data in Excel

I am working on my thesis right now and am having trouble creating the right graph for my data. I have two conditions (1-public, 2-Montessori) and a set of values based on the score of the children ...
0
votes
1answer
1k views

excel - how to connect a graph max with original (0,0) point

If I have a spreadsheet that has the following data: A 0 0 1 2 2 4 3 4 4 6 0-4 X Axis A is Y Axis First point is (0,0) Second Point is (1,2) Third point is (2,4) ...
0
votes
1answer
110 views

Customising error bars

I've been told I have to have custom error bars for an assignment I have to hand in. Okay, I have a scatter graph with twelve points, and the error for each one is different. It's the same plus and ...
0
votes
1answer
9k views

Prevent Excel from resizing graphs

When a row or column is inserted around a graph in Excel, Excel automatically resizes (expands) the graph. This corrupts the dimensions I determine for a specific graph. How can I prevent Excel from ...
-1
votes
1answer
128 views

Excel 2007 plot with labeled data items

I have data in the following format, where each label defines a row of data: label1 x1 y1 label1 x2 y2 label1 x3 y3 label2 x1 y1 label2 x2 y2 label2 x3 y3 This is a very large data ...
2
votes
0answers
52 views

Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its ...
2
votes
0answers
539 views

How to make a LibreOffice Calc XY (scatter) plot with named dots?

I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456"). I would like to know if I could have the content of a ...
2
votes
0answers
435 views

Create line graph with embedded horizontal histogram

How do I create these kinds of graphs: with the horizontal histogram counting the number of times the left graphs go through a certain range? I have access to Microsoft Excel and R.
1
vote
0answers
43 views

Excel: How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
1
vote
0answers
112 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
1
vote
0answers
34 views

Tool for associative graphing

I'm looking for an app or some computational way that would help me create interactive associated lists. Basically, I have three columns of data that have many to many relationships, and when one is ...
1
vote
0answers
179 views

How to make a 3d model from mathematical function graphs in each view?

I want to make a 3d model by graphing 2d mathematical functions in each view (top, left, front) to make surfaces for example in x-y view 2 curves with y1 = f(x), y2=f(x) and 2 straight lines make a ...
1
vote
0answers
370 views

How to plot this in iwork-numbers

I got an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I got another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from 0,51 ...
0
votes
0answers
9 views

Audio to graph software

I'm looking for a software that shows the opened/imported audio in a graph. I know there are some free audio editors like Audacity, but I'm looking for something that gives me control over the graph. ...
0
votes
0answers
52 views

Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...
0
votes
0answers
93 views

How can I graph the bitrate of an audio file?

I found a program called Bitrate Viewer, but it draws video bitrate only. Is there any way I can view the bitrate of an audio file as well?
0
votes
0answers
37 views

Are there File Managers where I can show connections between files in the same directory?

Without creating new directories, is there a file manager that can illustrate relationships between files/folders in the same directory? For example, I would like to turn something like this: ...
0
votes
0answers
61 views

Programs for reading data off interactive web charts

This question is in the same vein as this one: Program for reading data off scanned graphs Recently more and more interactive charts show up on the Net. Have a look at the following one: ...
0
votes
0answers
550 views

Excel 2007 adding mean value and variance to histogram

I have to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range). Example: Data: a,b,c,d,... ...