**1**

vote

**2**answers

653 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

**2**answers

274 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

**2**answers

363 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

**2**answers

35 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

**2**answers

409 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

**2**answers

4k views

### Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking.
My data might look like this:
London 23
London 22
London 44
London 18
...

**0**

votes

**2**answers

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

**1**answer

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

**1**answer

196 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

**1**answer

353 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

**1**answer

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

**1**answer

907 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

**1**answer

831 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

**1**answer

65 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

**1**answer

39 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

**1**answer

84 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

**1**answer

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

**1**answer

77 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

**1**answer

254 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

**1**answer

105 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

**1**answer

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

**1**answer

111 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

**1**answer

10k 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

**1**answer

131 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

**0**answers

55 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

**0**answers

552 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

**0**answers

455 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

**0**answers

44 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

**0**answers

121 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

**0**answers

37 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

**0**answers

182 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

**0**answers

374 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

**0**answers

28 views

### Excel scatter chart to show crossbar on selected point

Is there a way to configure Excel 2010 to show a crossbar on selected point in a scatter chart? The default behavior is to show a tooltip with the point's value when hover over the mouse cursor. When ...

**0**

votes

**0**answers

63 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

**0**answers

101 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

**0**answers

42 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

**0**answers

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

**0**answers

581 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,...
...