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

**2**

votes

**1**answer

9k views

### Create two axis stacked columns chart in Excel

The data I'd like to chart is like this:
2000 2001 2002
A x x x
B x x x
C x x x
D x ...

**2**

votes

**2**answers

3k views

### How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...

**2**

votes

**3**answers

42k views

### XYZ 3D-chart in Excel

I have a table of data as follows:
X Y Z
N1 2 5 6
N2 2 7 8
N3 0 1 2
N4 0 4 5
N5 9 10 10
N6 4 9 9
N7 0 2 4
N8 0 7 8
N9 0 7 8
Now I would like to ...

**2**

votes

**1**answer

110 views

### Can I use 2 different Columns of Data for the same axis & same series in Excel

I have a simple dataset in Excel showing Players, Win Count & Win %
I'd like on my Bar Chart to keep the % on the Vertical Axis like it currently...
But I'd also like to put the Win Count on ...

**2**

votes

**2**answers

247 views

### Graph-like data editor tool?

Is there any unified editor program for creating, mainpulating and visualizing graphs, trees... or maybe any custom structured data. The accent is on editing, not visualization, i.e. not a drawing ...

**2**

votes

**3**answers

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

**2**

votes

**1**answer

751 views

### Animate Excel Chart

I'm preparing for an Ignite talk and need to figure out how to animate an Excel chart, which will eventually go inside a PowerPoint. I would like to animate the following into a single chart/slide.
...

**2**

votes

**1**answer

513 views

### Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...

**2**

votes

**1**answer

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

**2**

votes

**2**answers

4k views

### Excel Scatter Chart with category based formatting of points

I have some data which I would like to plot in the scatter chart in the following format
date, category, value
01-Jan,Cat1,0.03
01-Jan,Cat2,0.13
01-Jan,Cat3,0.27
01-Jan,Cat4,0.32
...

**2**

votes

**1**answer

78 views

### Having trouble creating certain graph in Excel

I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal.
But when I try to recreate ...

**2**

votes

**2**answers

1k views

### How to create an Excel chart showing a value and its change?

I would like to create a chart that shows a value and how it has changed, like this one in Excel.
The importatnt thing (which I am not able to achive) is that there are two numers associated with ...

**2**

votes

**1**answer

1k views

### Windows programs to create timeline charts?

I would like to create a chart for my source control depicting the trunk and all the branches, with various details, like creation date, merge date, created revision, merge revision, close revision ...

**2**

votes

**1**answer

543 views

### Scattergraph in Excel?

I am not sure if this is the right site, though here's my question:
I've been trying to make a scattergraph with Excel, but not getting the result I want. I have 2 data values for one thing. I don't ...

**2**

votes

**2**answers

625 views

### How can I show a line chart in Excel (or Access) with category lines that ignore missing data?

I'm collecting data for various series (A-G), at sporadic intervals. I want a line chart, with one line for each series, that is connected even if there are intervals where no data was collected for ...

**2**

votes

**2**answers

4k views

### Placing labels on data points in a stacked bar chart in Excel

Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel?
I am trying to modify the timeline template available here so that my labels for ...

**2**

votes

**2**answers

536 views

### Best software to build charts (pies, bars) [closed]

I am somewhat disappointed with Excel charts and short of building my own with a vector graphics too, is there something really awesome for charts?

**2**

votes

**2**answers

68 views

### Indicating trends within sparklines in Excel

I have created a load of sparklines in Excel for a variety of diseases over time. However, in order to identify trends from these sparklines, it would be useful to include a little more information ...

**2**

votes

**1**answer

224 views

### Excel: How to create a nonuniform stack chart

I want to create a stack chart that shows the timeline of 3 phases on the x-axis (intervals separated by month) and total budget on the y-axis. The budgets for all projects will stack up against each ...

**2**

votes

**2**answers

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

**2**

votes

**1**answer

8k views

### A sensible way combine two stacked bar charts in Excel?

I have one chart that has several stacked bars with identical components - one for each category.
Each of the components of those bars can also be represented with a stacked bar chart, like the ...

**2**

votes

**1**answer

396 views

### Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.

**2**

votes

**1**answer

695 views

### Can I provide RGB hex strings in an Excel worksheet for pie chart colors without using code?

Like user1813558 in his question "Change the pie chart colors" I would like to choose the colors that Excel uses for a pie chart (indeed for any chart) as I need them to be consistent with other data ...

**2**

votes

**1**answer

4k views

### How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data.
However, some data is missing, resulting in zeroes in the calculated data which the chart uses.
When ...

**2**

votes

**2**answers

6k views

### Excel: Bubble chart labels - use 4th dimension?

I've got a dataset that has 4 dimensions - lets say they're the following:
+------------------------------+
| Type | Amnt |Price| Quality |
+-------|------|-----|---------+
| A | 15 | 4.0 | ...

**2**

votes

**2**answers

3k views

### Calculate the Y Axis interval for a chart

When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval?
I've been looking at Excel which seems to choose nice intervals like ...

**2**

votes

**2**answers

1k views

### Excel: ROUND() to the next unit of 5?

I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5.
...

**2**

votes

**1**answer

2k views

### Excel graphs: How do I apply a graph template format?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...

**2**

votes

**1**answer

665 views

### Plotting the volume of an audio file

Most applications that play sound display its volume graphically. I need that information (the sound volume as it changes over time) written to a text file so I can plot it myself and use it for ...

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

**2**

votes

**1**answer

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

**2**

votes

**1**answer

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

**2**

votes

**1**answer

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

**2**

votes

**1**answer

1k views

### Make two or more graphs have the same scale

I have several area graphs in an Excel spreadsheet. I want all of those graphs to have exactly the same scale.
Each of the graphs have a measurement in meters on each of the axes. I want each of the ...

**2**

votes

**1**answer

2k views

### Add custom forecasting line in Excel Charts

I got the following graph (in purple):
I want to add the dotted forecasting line.
It's a cell value, but not referenced to the point on the X-Axis (Oktober 13).
I'm a bit lost as to how I could ...

**2**

votes

**1**answer

8k views

### Excel 2010 chart does not show x axis value

In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis ...

**2**

votes

**1**answer

192 views

### Create pie chart with single sector separated from the rest?

Is it possible to use LibreOffice (I'm currently using 3.5.4) to create a pie chart where a single sector of the chart appears removed from the rest?
If so, how to do it?
Alternatively, can someone ...

**2**

votes

**1**answer

552 views

### excel chart dynamic range based on values

I'm trying to create a chart that auto updates itself from a data provided. The range of the chart is always fixed/locked. The issue I'm facing is that when a value for a certain month is 0, I want it ...

**2**

votes

**1**answer

352 views

### Graph with uneven spacing in excel

I need to make a graph of follow-up data at 0, 6, 12, and 24 months. Excel for Mac 2008 puts the 24 months at the 18 month position. How do I get the correct spacing without including 18 months?

**2**

votes

**2**answers

300 views

### Manually “draw” data for chart, output to CSV

I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...

**2**

votes

**1**answer

314 views

### Why am I unable to use a named range beginning with “Corona” in Excel charts?

I'm running into a ridiculous problem in Excel 2010 where I cannot seem to use a named range whose name begins with "Corona" in a chart. I've created a new workbook with a simplified version of the ...

**2**

votes

**3**answers

4k views

### Vertical Histogram in Excel with Conditional Formatting

I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...

**2**

votes

**2**answers

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

**2**

votes

**2**answers

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

**2**

votes

**1**answer

2k views

### Can I crop an excel chart to remove part of the chart?

I followed some instructions to create a speedometer chart (pie chart with a scatter line chart on top).
However, this solution leaves a large blank space below the chart; 50% of the chart's space is ...

**2**

votes

**2**answers

408 views

### Excel auto Gantt chart

I have a spreadsheet with 4 columns. Teachers, Class Taught, Class Start (date), Class End (date). I need to plot this in excel somehow to show what days of the month are booked by each teacher.
I1 ...

**2**

votes

**1**answer

2k views

### Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...

**2**

votes

**1**answer

1k views

### How to create a XY (scatter) chart with three columns of data?

I have the following data:
Date Name Value
1/1/2011 FOO 10
1/1/2011 BAR 12
2/1/2011 FOO 16
3/1/2011 BAR 21
5/1/2011 FOO ...

**2**

votes

**4**answers

14k views

### How can I create proportionally-sized pie charts side-by-side in Excel 2007?

I have a pivot table with two sets of data as follows:
2011 2012
Slice A 45 20
Slice B 33 28
Slice C 22 2
I am trying to present two pie charts ...

**2**

votes

**1**answer

429 views

### Excel distorting markers in scatter plot

I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For ...