**1**

vote

**2**answers

655 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

278 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

365 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

36 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

427 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

92 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

361 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

936 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

839 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

8 views

### Icon size of OriginLab virtualised on Mavericks

I hope that someone can help me because I'm freaking out!
I just installed Origin 9.1 on a Mac (15 retina late 2013) using parallels 10 on Windows 8.1
Everything is fine, but, due to the high ...

**0**

votes

**1**answer

92 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

87 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

78 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

255 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

133 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 ...

**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

187 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 ...

**0**

votes

**0**answers

7 views

### Lines over data in Excel 2013 Scatter Graph

I'm having some problems getting the plot order in a Excel 2013 scatter plot right. One series should have markers ("raw data") which should appear below series with markers and line ("fit"). The ...

**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

64 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

104 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

43 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:
...

**-1**

votes

**0**answers

10 views

### 2d density graphs with R

I would like to plot a 2D density plot using R. I have a 2 dimensional data and would like to plot it in such a way that the dense part (with data points) of the graph is represented as red and less ...