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

**0**

votes

**1**answer

704 views

### Excel area chart - y axis and major grid does not match 1 of the 2 series values

Using an area chart to show survey responses as two series with four data points in each. The x-axis are the four answer choices, the y axis is the percentage of respondents.
The problem is the data ...

**0**

votes

**0**answers

1k views

### How to get data series in Highchart from a JSON POST request (cross domain)

I'd like to create my own Highstock's chart on a local html file by using the JSON data series retrieved with a POST request to a third-party domain.
I've read several docs on Highcharts' website but ...

**0**

votes

**2**answers

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

**1**

vote

**1**answer

452 views

### Cannot insert charts into PowerPoint 2013

I cannot insert charts into PowerPoint 2013. Each time I wish to, once I have selected the desired chart type and click 'OK', it simply blinks (exits and reopens). It then returns me to the same ...

**-1**

votes

**1**answer

2k views

### How to create a 4 variables chart in excel? [closed]

I have been trying to figure out a way to create a chart with 4 variables in Excel. I can get to 3 with no problem but the 4th variable seems not possible.
Here is my data (I am working with decoding ...

**0**

votes

**2**answers

222 views

### How to make a 3D chart in excel

I found the same question but I'm not getting a 3D looking chart as posted in the answer.
My data looks like this:
5 7 11 15 19
0.1 28 21 12 9 7
0.2 22 14 9 ...

**0**

votes

**1**answer

685 views

### graph in excel to represent correlation of 3 parameters

I have some data in excel and I would like to make a graphical representation of those data. Structure of my data:
persons ID : from 1 to 485 to every person, there is one parameter like average ...

**0**

votes

**1**answer

94 views

### Excel Chart Timeline

I have a CSV file that I have opened in Excel 2011 for Mac.
The CSV looked like this:
Timestamp | URL
01/Jan/2014:01:01:01 /path/to/something1
01/Jan/2014:01:01:05 ...

**1**

vote

**1**answer

422 views

### Display numbers twice on x axis in excel chart

I have following values that I would like to display on the X axis of my chart:
0,1,2,3,4,5,6,7,8,9,10,10,10,9,8,7,6,5,4,3,2,1,0
But my chart is displaying the values as ...

**3**

votes

**0**answers

196 views

### How to chart time of day in Google Spreadsheet with midnight crossover?

I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after ...

**1**

vote

**1**answer

848 views

### Set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

Is there a way to set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well?
Basically I have a number of different stocks I'm ...

**2**

votes

**0**answers

404 views

### Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows
Mean values 61 43
Sample 1 0.009 0.059
Sample 2 0.108 0.099
Sample 3 0.043 0.038
...

**1**

vote

**2**answers

10k views

### Excel scatter plot with multiple series from 1 table

Say I have a table as follows:
Label | X | Y |
A | 1 | 1 |
B | 2 | 2 |
B | 3 | 2 |
A | 4 | 3 |
C | 5 | 4 |
A | 4 | 3 |
C | 2 | 1 |
How ...

**0**

votes

**0**answers

21 views

### Excel scatter plot with labels [duplicate]

I need to make an excel scatter plot.
Col A = Names
Col B = X axis
Col C = Y Axis
Doing a scatterplot on B,C makes the right chart.
However, how do I add little labels to each point with the ...

**1**

vote

**3**answers

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

vote

**1**answer

81 views

### How to plot excel chart with multiple series from single data source

How do I plot the following multiple series information on a single chart:
DateTime SeriesName Duration
2014-05-02_10:21:21 X 2013.006
2014-05-02_10:21:22 Y ...

**1**

vote

**2**answers

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

**2**answers

74 views

### Excel plot digitizer [closed]

Is there any plot digitizer usable in Excel? I have discrete points (values X and Y) and I have to create graph from these - Excel can create the "mean curve" (I am sorry, I am not a native speaker so ...

**0**

votes

**2**answers

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

**0**

votes

**1**answer

3k views

### Excel chart with a single x-axis but two different ranges (combining horizontal clustered bar and horizontal stacked bar), possible?

I am new here. I have a data set of density values (phytoplankton community) according to depth and the composition of it in percentage. I want to ask if it is possible to construct the density values ...

**1**

vote

**2**answers

178 views

### How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like:
5/29/2011
6/21/2011
6/26/2011
7/1/2011
7/3/2011
...

**1**

vote

**1**answer

1k views

### Changing the units on the x-axis in a LibreOffice Calc chart

I've used the LibreOffice chart wizard to make a chart, and I would like the x-values to be different to the default of 1,2,3... (in this case, 500,1000,...). How can I do this?

**0**

votes

**1**answer

445 views

### How do I group and chart date ranges in Excel?

I want to visualize the use of vehicles in a family through time. I have collected the dates each vehicle was being used as follows (example data) :
And want to somehow chart the data to visualize ...

**1**

vote

**1**answer

1k views

### What are the labels for minor ticks in a log scale graph?

What are the labels for the minor ticks in a log scale graph?
I would like to label them. So, I want to know how to calculate the value for each of the minor tick.

**1**

vote

**2**answers

1k views

### In Visio, how do I create a chart with coordinates throughtout time

I have these data (from MSSQL, that I converted into Access/Excel) on a moving object in a defined space
x y time
0 0 07/04/2014 08:48:07
5 5 07/04/2014 16:35:25
6 4 ...

**0**

votes

**1**answer

143 views

### Excel - Quickly Charting Frequency of Event To IP Address Over Time

Warning: Keywords and tricky phrases may not be correctly being used here. I'm not extremely knowlegable about the terms used with Microsoft Excel so I'm using my best guess.
I'm failing to find a ...

**1**

vote

**1**answer

632 views

### How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where:
Column A is filled with arbitrary dates sorted by increasing age
Column F has numeric data relevant to this question
Row 1 is the ...

**3**

votes

**2**answers

57 views

### Automatically updating bar chart?

So for a project at work I have a table in excel that contains numbers for each month of the year up to this one in four categories. It looks (a bit) like this:
...

**2**

votes

**0**answers

85 views

### Automatic scatter plot in Excel 2010 [closed]

I have two quite large data sets of which I want to plot every line in one plot.
The pattern is the following:
x-axis: Set one (Colonne 1-6)
y-axis: Set two (Colonne 1-6)
Now I want such a plot for ...

**1**

vote

**1**answer

72 views

### Word: remove space before paragraph with picture

I'm writing a paper and adding charts surrounded by the text has been quite a pain. Currently I have one chart that sits in the top left corner of a page. There is approximately 4 cm left after the ...

**0**

votes

**1**answer

288 views

### How to create line chart in Excel with two series of ordinal/nominal data?

I have these two columns in Excel.
Result Speed
------ ----
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
MEDIUM HIGH
HIGH HIGH
HIGH HIGH
HIGH ...

**2**

votes

**1**answer

1k views

### How to make Excel chart axis start NOT at major unit?

Is it possible to have an Excel chart where the axis does NOT start at the major unit?
See the example below, where I want the x-axis to start at the year 2007, but have major unit 5 years and show ...

**1**

vote

**2**answers

156 views

### How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises.
Here is the data:
...

**3**

votes

**1**answer

198 views

### How can I have automatically updating copies of charts?

I have been doing some more complex work with Excel (different tabs/worksheets, etc.).
Now I have some charts from one worksheet that I'd like to kind of embed in the other worksheets for the purpose ...

**0**

votes

**1**answer

2k views

### Excel Chart from Multiple Sheets

I have a bunch of sheets and each one has a value in cell K15 and call K20. How do I make a stacked column chart that shows these values stacked for each sheet?
Forgive my crude drawing, but ...

**2**

votes

**1**answer

65 views

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

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

**0**

votes

**1**answer

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

**1**

vote

**1**answer

101 views

### Excel Scatter Diagram

I have data in Excel as follows (just example of them, not all):
Name | Asset | Count
-----------------------------
John | Apple | 1
Adam | Banana | 2
Pete | Apple | 1
Mark | Berry ...

**-1**

votes

**1**answer

39 views

### How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart:
I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...

**2**

votes

**1**answer

521 views

### Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this:
2014-02-20 23:04:57.9263690 +00:00
2014-02-20 23:05:02.3117944 +00:00
2014-02-20 23:05:02.7490564 ...

**1**

vote

**1**answer

735 views

### How do I link to excel chart data in PowerPoint with relative paths?

This question is similar to the question posted in
How do I embed video in PowerPoint with relative paths?
But in my case I search for an answer to get Excel charts, which are linked in an absolute ...

**-1**

votes

**1**answer

3k views

### How to combine multiple trendlines in a single chart?

I'm new in here and I love the forum already! I'm stuck with a problem now. I am doing financial ratio analysis of a company for five years and I need to show the ratios in a trendline. I have ...

**0**

votes

**1**answer

4k views

### How to plot negative numbers in Y-axis in Excel 2013

I have created a chart of Sales and Growth over a period of years... The growth is negative in a couple of years.
A normal combo chart with Sales in Primary Axis and Growth in Secondary axis looks ...

**2**

votes

**1**answer

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

**3**

votes

**3**answers

2k views

### How to change Excel chart size with screen size

I have a Excel spreadsheet that is edited primarily from my desktop
computer at work (which has two large screens) but is also sometimes
edited on my personal laptop computer from home (which has one
...

**1**

vote

**1**answer

290 views

### Two problems with Excel graphing

See the following figure
I have two problems with Excel 2013, I am not sure how to solve these:
1) The axis title overlaps the data values on all my axes. From the figure, I am unable to change ...

**3**

votes

**2**answers

76 views

### X axis labels with “super-categories” or “headers”

How do I make the X axis labels of a column chart looks like this? i.e. with, for lack of a better name, "super-categories" or "headers", like the labels "All sites", "All sites excluding LR" etc. in ...

**1**

vote

**1**answer

3k views

### Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form:
X | Y
----+-----
3 | 42
4 | 57
6 | 92
11 | 119
19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 ...

**2**

votes

**1**answer

17k views

### Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data:
Date (from 1st till 31st)
Variable 1
variable 2
I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis,
I plot the date on the graph ...

**1**

vote

**1**answer

151 views

### How to: edit data in excel, visualize it on a second screen whilst live?

Suppose I have the following set-up:
I have a laptop connected to a screen. The screen shows whatever. The screen is in front on an audience who are asked to choose between several alternatives, say ...