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

**5**

votes

**3**answers

7k views

### How to fill in missing dates in chart

I'm looking for a simple way to chart a list of values each correlating to a date. For example:
Date Value
11/7/13 2
11/8/13 2
11/11/13 3
11/14/13 2
Etc. The problem is, the chart does ...

**0**

votes

**2**answers

79 views

### Finding trends in multi-category data in Excel

I have an Excel spreadsheet that contains hundreds of rows of data that each represent a single sample in a larger population. Each row is divided into three columns that contain frequency counts of ...

**3**

votes

**1**answer

369 views

### How to antialias trendline in Excel?

I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly:
I have tried ...

**-1**

votes

**1**answer

243 views

### Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV.
How is it possible to ...

**0**

votes

**1**answer

4k views

### Adding text axis labels to excel scatter chart

I have a Spreadsheet with data like this
Label Data
PA_1 1
PA_2 2
PB_1 3
with hundreds of rows.
I want to create a scatter graph where the x-axis contains the names in the label column.
...

**5**

votes

**2**answers

2k views

### Linked images in PowerPoint not updating

First of all, excuse me if this question is asked on the wrong StackExchange site.
I have a PowerPoint (2010) presentation with two slides. Both slides contain an image (two different images), and ...

**2**

votes

**1**answer

8k views

### Advanced Chart in Excel - column width based on cell value

I am an intermediate excel user struggling to create a specific chart for an internship project. I have spent a lot of time trying to figure it out and have searched the web extensively.
Below is an ...

**10**

votes

**2**answers

480 views

### How to turn a 3D chart into something watchable on a 3D television?

Let's say I have a 3D scatter plot in R or a data frame with 3 fields filled with numeric data.
How can that be "turned" into "something" watchable on a 3D television (like a random big screen TV ...

**0**

votes

**1**answer

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

476 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

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

200 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

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

**4**

votes

**0**answers

395 views

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

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

**2**

votes

**0**answers

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

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

246 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

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

82 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

111 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

455 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

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

**13**

votes

**2**answers

138k views

### Excel chart with two X-axes (horizontal), possible?

Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ?
I want to use the second axis to plot the normalized value of the default horizontal axis.
...

**1**

vote

**2**answers

249 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

**3**answers

11k views

### Is it possible to have a custom data table visible underneath a chart in MS Excel?

I have a column chart with a single series of data to be shown on the chart.
However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...

**0**

votes

**1**answer

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

**1**

vote

**5**answers

647 views

### Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08
X A 12 10
X B 8 15
Y A 52 0
Y B 5 5
Every day I ...

**-1**

votes

**1**answer

46 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

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

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

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

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**4**

votes

**1**answer

17k views

### How to have Excel chart connect data points when no value?

I'm charting daily values using a line chart. On some dates, I don't have any data. I would like the chart to connect the data points for which I have data across any gap in data.
So for example if ...

**0**

votes

**1**answer

332 views

### How can I create an automatically updating chart from a different worksheet with blank spaces in excel 2010

I have a worksheet that lists every day so I can see if any tests were performed that day. If there were tests, then the average and standard deviation of that day show up in the next two columns. I ...

**6**

votes

**4**answers

1k views

### How can I make a pictograph?

How could I make a chart similar to the one below?
Of course, I could use an app like Microsoft Paint, but that would be too time-consuming and awkward. What would be a simple way to do this?

**1**

vote

**1**answer

2k views

### Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...

**0**

votes

**1**answer

6k views

### How do I create bar charts with ranges as the x-axis in Excel 2010?

I am trying to create a bar chart for say some data, say for example
1 1 2 2 3 4 5
I want to create a bar graph so each bar shows the frequency of a range. For example, the frequency of a value ...

**0**

votes

**0**answers

261 views

### how can i capture a flash object thats displayed by the browser but the swf file is kind of protected, like on scribd

i want to download a stock's intraday price chart. its a flash object. dont know whether its protected in such a manner as to not allow it to be saved on to the disks of end users(like certain files ...

**0**

votes

**0**answers

54 views

### The Specified Dimesion is not valid for current chart type

I am trying to open a file into which I will copy the data from the previous file but I am getting an error while opening the other file.
Here is my code
Dim WSC, WSD As String
Dim Filter As String, ...

**1**

vote

**1**answer

1k views

### Chart Categories: How To Combine X-Axis Categories

The Task
I'm putting together a dashboard wherein I'm building several charts. I've attempted to use a pivot chart (2D line chart) to pull data from two different pivots (with the same source data). ...

**0**

votes

**1**answer

379 views

### Excel: resize chart sheet

I can create a chart sheet in Microsoft Excel 2010. I wish to resize the chart so that the proportions fill my wide screen. I right-click the chart and select Format Chart Area. Then I select the Size ...

**0**

votes

**1**answer

270 views

### Excel stacked column chart with unconventional data set

I'd like to create a stacked column chart based on the following set of data:
Region Segment Value
EMEA Premier 20
EMEA Standard 10
Americas Premier 30
Americas Standard ...

**0**

votes

**4**answers

8k views

### My pivot chart has the wrong Y axis values but correct data point values

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values.
The values on resulting lines are correct (see the data label at the end of the line) ...

**1**

vote

**1**answer

1k views

### Color bands in bar charts in Microsoft Excel 2010

Is it possible to obtain a bar chart like the one in this example:
(that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.)
Any ideas?

**2**

votes

**1**answer

59 views

### X-axis changes Excel plot output

I have the following Excel file:
https://dl.dropboxusercontent.com/u/33532467/GDV_Prognose_Leben.xlsx
The green hatched area is not shown properly. I would expect:
The horizontal axis seems to ...

**2**

votes

**2**answers

341 views

### Three pairs of box whisker plots in one coordinate system

I need to plot in Excel 2007 something which looks like this:
Basically I want to plot 2 box whisker plots, then have some empty space and then again 2 box whisker plots, followed by empty space ...