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

learn more… | top users | synonyms (3)

1
vote
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
446 views

Free software to plot cartograms

Is there any free software to plot cartograms?
0
votes
3answers
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
7answers
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
4answers
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
1answer
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
2answers
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
2answers
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
4answers
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
3answers
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
1answer
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
3answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
5answers
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
4answers
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
4answers
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 ...