Graphs, charts and other graphical methods for showing data and their relationships.

**1**

vote

**2**answers

95 views

### Excel: How is this graph even possible?

I made a line graph using two sets of data:
However, the blue line is totally out of place somehow and I have no idea why. I feel like I've checked everything. What could be going wrong?

**1**

vote

**1**answer

3k views

### Lines over data in Excel 2007 Scatter Graph

I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second ...

**1**

vote

**2**answers

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

**1**answer

554 views

### Excel 2007: plot data points not on an axis/ force linear x-incrementation without altering integrity of non-linear data

In Excel, how does one go about plotting points that don't have an x component that is an x-axis label?
For example, in my graph, the x-components are derived from the cosine function and aren't ...

**0**

votes

**1**answer

4k views

### Excel 3 dimensional stacked bar chart howto

One of our guys in the office wants to do a proper 3D stacked bar chart. In other words, he is not just interested in having a 3D rendering of the bars, but he needs full 3 dimensions for his data (x =...

**0**

votes

**1**answer

128 views

### Creating a graph for data in Excel

I have two conditions (1-public, 2-Montessori) and a set of values based on the score of the children that is either a 0 or 1.
I need a histogram showing how many children got a 0 and how many got a ...

**2**

votes

**2**answers

51k views

### Easily Plotting Multiple Data Series in Excel

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...

**0**

votes

**1**answer

248 views

### Formula in Excel graph

I am creating a line graph in Excel 2007. What I would like to achieve is to specify a formula in the chart data range.
What I have now in the chart data range is:
=SHEET1!$B$1:$W$1;SHEET1!$B$7:$W$...

**2**

votes

**2**answers

8k views

### Excel graph - two lines, one axis with date

I want to make Excel chart that shows my accounts' balances in time.
I have 2 bank accounts and I have all transactions saved in Excel. The data's format is:
Column A Column B Column C Column ...

**0**

votes

**1**answer

428 views

### Excel per-point custom error bars

I am attempting to draw error bars on a multiple bar graph in Excel 2007, and I am having trouble with the custom error bar minimum value. First, I created the graph from multiple series, then I ...

**1**

vote

**1**answer

446 views

**0**

votes

**3**answers

61 views

### Tools for drawing this graph

what is the best tool for drawing this kind of graph? I tried in MS Word but they were not as good as this.

**8**

votes

**7**answers

6k views

### How to easily plot graph, using (preferably) free software?

I need to plot a graph, given some data, where on X axis will be names of data and on Y axis those data, and it will be given by a table, and it will be line graph with the data connected. If there ...

**0**

votes

**1**answer

527 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

28 views

### Creating a custom y-axis that goes 0, 80, 160, 320, 640, ect

I am wondering if there is a way to make a graph on excel with a y-axis scale based on a function y(n)=2 X y(n-1).
Specifically, I want a y-axis that has values 0, 80, 160, 320, 640, 1280.
Thanks in ...

**0**

votes

**1**answer

124 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

**2**answers

204 views

### Excel bar graph, easy idea, hard implementation apparently

I want to make a graph like this, but I can't seem to make it correctly:
Data: 4, 2, 3, 4, 1, 3, 3, 2, 3, 4, 2, 3, 2, 1
Three elements: Y-axis potential values (1-4 or worst, below average, above ...

**4**

votes

**3**answers

7k views

### Graphical GUI for Graphviz on Mac?

I installed the Graphviz GUI from pixelglow.com, but it appears to only be a viewer for .dot Graphviz files. I am looking for a graphical editor, where I can create diagrams by pointing and clicking--...

**0**

votes

**1**answer

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

**4**

votes

**4**answers

540 views

### Good graph plotting app

Does anyone know of a free graph plotting app for windows (or online) that can plot something like this?
Xn+1= r sin (π * Xn)

**3**

votes

**1**answer

26k 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 ...

**0**

votes

**2**answers

2k views

### Superscripts in Excel chart labels

I have data like this in two columns:
2 | 5
4 | 6
8 | 7
I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol ...

**1**

vote

**2**answers

13k views

### How to get charts to automatically update with new data added?

If I were to have data in excel just like the table below, and then make line charts with that data. All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data. ...

**1**

vote

**3**answers

942 views

### How to create a Horizon Graph in Excel?

Does anyone know how to create a Horizon Graph in Excel (preferably without needing to download an Add-In)? I believe these were originally called, "two-tone pseudo charts" developed by Saito and ...

**-1**

votes

**1**answer

6k views

### Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this:
It might ...

**0**

votes

**1**answer

1k views

### Scatterplot with variable X on X axis and Y on Y axis

I have a dataset with variable A (Age) and B (performance). I want to create a scatterplot with variable A on the X axis and B on the Y axis, but Excel is acting all weird with it.
I have approx 120 ...

**2**

votes

**1**answer

2k views

### Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...

**4**

votes

**2**answers

558 views

### Drawing sample points versus time in Excel

I have a set of data as follow:
As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time.
I need to present this in a chart (I ...

**4**

votes

**1**answer

35k views

### Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars.
...

**3**

votes

**1**answer

7k views

### possible to have two Y axes and two X axes on same chart

Is it possible to have a chart with
left Y axis
right Y axis
top X axis
bottom X axis
all on same chart?

**1**

vote

**1**answer

2k views

### Bar chart in Excel 2010 with values over maximum

How can I make a chart like this in Excel 2010?
Image from: EPA.gov
I have data where two out of 20 values are disproportionately large. In order to create a useful chart I'd like to cut out a ...

**2**

votes

**1**answer

946 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
&...

**1**

vote

**1**answer

2k views

### Plot disproportionate values in single graph with Excel

I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One ...

**1**

vote

**1**answer

99 views

### Given multiple start dates, how to assign counts to relative date values?

I'm trying to create a before-and-after graph in Excel, lining up multiple milestone dates at month zero, and assigning relative month numbers to months prior and subsequent to milestone month.
My ...

**0**

votes

**2**answers

68 views

### Having some issues making specific line charts in Excel

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 from excel to make it look better. Here is ...

**0**

votes

**2**answers

7k views

### Make the first row of an Excel chart be treated as a heading when it's a number?

Given a data sample like
Prisoner 24601 0.50
Day 1 80 90
Day 2 81 89
Day 3 82 90
Day 4 81 91
What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather ...

**1**

vote

**2**answers

16k views

### Excel Charts - How do i plot time on the Y axis

I am a keen runner and am trying to plot my progress on a chart using the following times
00:27:18
00:28:19
00:26:49
00:27:19
00:26:05
00:27:18
00:26:22
00:26:49
00:30:40
00:28:03
00:26:58
00:27:35
...

**9**

votes

**4**answers

32k views

### Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to ...

**10**

votes

**3**answers

69k views

### Making line charts so the line goes through all data points

I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around?
I've ...

**4**

votes

**1**answer

2k views

### Any alternatives to Ubigraph?

Ubigraph is a different way to create interactive user interfaces with the purpose of visualizing huge amounts of data. Its visualizations are simply stunning.
The problem is that the project seems ...

**0**

votes

**3**answers

4k views

### Relative Gantt in MS project?

Is there a way to create a relative Gantt in MS project, that is a Gantt that doesn't have a defined start date, just amount of time required for each task?

**2**

votes

**2**answers

7k views

### Graphing mean and standard deviation

I have measurements for multiple devices, and have their mean and sd values. I would like to produce a chart that would show these values, and I think the best would be if I could have something that ...

**2**

votes

**1**answer

170 views

### Make dates appear on the X-axis and the color category appear on the Y-axis

There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
10/...

**1**

vote

**1**answer

6k views

### Adding 80% horizontal goal line to pivot chart

I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line.
I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...

**0**

votes

**2**answers

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

**3**

votes

**1**answer

1k views

### Create graph for requests per minute and uri

I have a table that looks like this.
time|uri
08:50:28|foo
08:51:42|bar
08:52:48|foo
08:53:49|bar
08:53:50|baz
08:54:02|bar
08:54:03|baz
08:55:27|foo
08:55:34|baz
08:56:47|bar
I would like to make ...

**5**

votes

**2**answers

18k views

### Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text labels,...

**3**

votes

**5**answers

342 views

### Any good 'how to…' resources out there? [closed]

Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts?
I've reached the point where I need to do more than tables. ...

**2**

votes

**4**answers

9k views

### How to make bar graph shorter for higher numbers?

I would like to inverse the bar graph in a way that the lower the number, the higher the bargraph should be.
Currently in the picture below, those items ranked 200 have the highest bar height while #...

**1**

vote

**4**answers

160 views

### Any good online chart generators? [closed]

I am looking for some free site that allows you to easily create a chart from provided data (in interactive mode, so I don't have to write any code) and export it to an image. Can anyone recommend ...