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

**1**

vote

**1**answer

11 views

### Excel Chart with data points not in chronological order

Say you have total monthly spend for 36 months and you want to display it in a bar graph to show all the spend for the 3 Januarys, then all the spend for the 3 Februarys, etc. When I sort my data ...

**1**

vote

**4**answers

33k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**3**

votes

**1**answer

27 views

### Excel 2010 create pie chart with labels which apply to more than one segment

I want to create a pie chart with data labels which refer to more than one segment.
I have found an approximate way of doing this - these are the steps I followed.
My data looks like this:
I want ...

**0**

votes

**1**answer

13 views

### Change linked data in a chart embedded in Word

I have set up six charts on a page, so that they're all the same size and formatting. But at the moment there are only two distinct charts and each one has three versions. I did this because I didn't ...

**0**

votes

**1**answer

27 views

### Histogram over Time?

I am trying to track the progress of a similar variable on a number of (several thousand) objects over time. I have several snapshots of data in the following form, but I want to show the progress ...

**1**

vote

**2**answers

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

12 views

### How to fix corrupted Visual FoxPro 9 dbf, dbc? [on hold]

When trying to open tables I get the message "is not a table.
I have tried DBF Recovery and it did not work.

**0**

votes

**0**answers

17 views

### Excel chart referring to non-existant sheet

Apologies in advance if this question is very vague.But I'm hitting my head against the wall on this for the past 2 days and hoping someone can point out the obvious to me.
We have an Excel Report ...

**0**

votes

**1**answer

25 views

### How do I keep formatting on an Excel 2010 Pivot Chart?

I have some VBA code that runs a SQL Query, dumps it into an Excel 2010 spreadsheet and refreshes the 2 Pivot Tables based off the data. I also have 2 Pivot Charts based off of the Pivot Tables, and ...

**3**

votes

**2**answers

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

**1**

vote

**1**answer

24 views

### How can the placement of data points in a graph be adjusted?

As part of an important presentation, I've created the following diagram showing statistical data over 5 periods of time.
The data for each period consists a pair of a bar charts with a ...

**6**

votes

**7**answers

71k views

### How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls:
Note: You could also call it a binomial mass distribution for p=1/6, ...

**0**

votes

**1**answer

3k views

### Excel scatter graph fill inside shape

I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart ...

**0**

votes

**1**answer

3k views

### Visio 2013 - Flowchart Legend

I get the following error when I try to insert a legend into my visio diagram (flowchart):
There are no suitable data graphics on this page. If you apply a
data graphic, you can usa a legend to ...

**4**

votes

**1**answer

12k views

### How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example:
Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart.
Is it ...

**0**

votes

**3**answers

25 views

### How to get a particular y value on a graph from Excel

Here below is my Graph:
Let's say I have a reading of 1.02 ml (the x-value from the graph) from my buret, how do I find the corresponding y-value?

**0**

votes

**3**answers

3k views

### excel - how to connect a graph max with original (0,0) point

If I have a spreadsheet that has the following data:
A
0 0
1 2
2 4
3 4
4 6
0-4 X Axis
A is Y Axis
First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
...

**1**

vote

**1**answer

26 views

### Excel Charts: Is it possible to add specific text to the bars on a chart?

I have a chart which shows the daily purchases of each day in August 2015 against the daily purchases of each day in August 2015 in the bars, the lines show the total purchases in August 2014 for each ...

**0**

votes

**1**answer

3k views

### How to combine Excel charts on same X-axis

I want to create two stacked graphs in one chart object. One should be Stacked Column, and another Stacked Area. They represent revenue per partner per week of the year. On x-axis are weeks of the ...

**2**

votes

**3**answers

4k views

### how to extract data from an image graph

I'm looking to get that from a graph. but problem is that graph is in image form. Now I want to extract data in excel from that graph. how can i do it? I'm using office 2003.

**0**

votes

**1**answer

1k views

### Optimally positioning pie chart data labels in Excel with VBA

I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size.
I want to display the data labels ...

**5**

votes

**4**answers

91 views

### How to setup stacked bar chart to graph medication doses?

My Mom is sick (cancer) and my Dad has been writing down the times that he has administered pain medications to her. He asked me to plug it into a spreadsheet and chart it so he can visualize trends ...

**8**

votes

**2**answers

38k views

### Excel: How to display superscript text as data series on chart?

I have a line chart in Excel 2007 that is created from data in the worksheet. It has several series whose titles are displayed in the chart on the right side. The names of the series are of the form ...

**11**

votes

**8**answers

78k views

### Map one column to x axis second to y axis in excel chart

I'm getting my ass kicked trying to plot simple data into a simple chart in excel (2010 beta).
My data is a very simple one:
Value Year
----- ----
1 1900
5 1902
3 1912
...

**2**

votes

**1**answer

4k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

**0**

votes

**1**answer

19 views

### Excel 2013: Adding a formula / function to a chart legend

I have a chart in Excel with three legend entries. Each of them contains the word "Umsatz" and all of them are linked to cell values. Now I would like to remove that word from the entries with a ...

**3**

votes

**1**answer

37k views

### How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...

**0**

votes

**1**answer

25 views

### Odd issue with Excel pie charts

I am having a weird issue that I was hoping was a quick fix with Excel 2013 for a pie chart. However, I can't figure out what's wrong! I am attempting to make a pie chart out of a column that looks ...

**1**

vote

**1**answer

41 views

### How to Fix Excel Graph to stop drawing line when data ends (not auto extend line to zero)?

I am using Excel 2010.
I am trying to graph actual expenditure data (a solid line) and extend that graph into the future (a dashed line).
I have a 5 column sheet. The first column is a date column ...

**2**

votes

**2**answers

64 views

### Eliminate the appearance of a dip when plotting increasing data with smoothing

I have a data set in which Y is an increasing function of X. Here is the data:
5 | 0.1
10 | 0.789
15 | 147.5
20 | 216.5
25 | 276.5
I create an XY (Scatter) Chart with Smooth Lines:
...

**-1**

votes

**2**answers

88 views

### Connecting multiple series on Excel scatter plot

I am trying to create a scatter plot with multiple series and have them connected.
My data has multiple Y values for a single X value. There are 4 X values and 7 Y values for each X value for a total ...

**1**

vote

**2**answers

47 views

### Add Baseline to simple Excel chart

I have a simple Excel spreadsheet tracking weight loss. I have a column with dates and another with weights. I made a simple chart with both columns as data sources (dates are x, weight is y). That ...

**0**

votes

**1**answer

5k views

### Excel chart does not show all data series

I'm trying to set up an Excel chart. I've tried to enter 6 data series. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right-hand side listing of series, it shows ...

**0**

votes

**3**answers

75 views

### How to tell Excel that “Years” are “Years”, not data

I have googled everywhere about this but no solution found. I have three columns in Excel:
A: Years, from 1960 to 2013
B: Maize production (in tonnes)
C. Wheat production (in tonnes)
If I make a ...

**2**

votes

**1**answer

104 views

### Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...

**-1**

votes

**1**answer

49 views

### How to plot three sets of data in Excel? [closed]

I have 3 sets of data that show the specimen weight
W1 W2 W3
0 0 0
36 64 100
68 106 150
96 134 190
120 158 220
140 179 245
156 195 265
170 207 280
182 215 290
190 222 298
194 227 305
194 230 ...

**2**

votes

**1**answer

3k views

### How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...

**2**

votes

**2**answers

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

**1**

vote

**0**answers

45 views

### How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B.
However the 100% stack column chart doesn't seem to work if I have a ...

**-1**

votes

**2**answers

638 views

### Generate heatmap using list of IP addresses [closed]

I have a list of IPv4 addresses and I want to generate a heatmap of where the IP addresses are located. Is it possible to do it? IF it is possible can anyone please tell me how to do it?

**4**

votes

**1**answer

56 views

### How to customise labels on a secondary axis to show student progression as a flight path in Excel?

I am trying to create a line graph in Excel that plots a student's actual progression against their predicted grade. The type of graph is called a 'flight path'. This is represented as two lines on ...

**0**

votes

**2**answers

98 views

### Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc.
I'd like to have a stacked bar chart that lines up with these intervals, but so far ...

**1**

vote

**1**answer

35 views

### Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...

**0**

votes

**0**answers

32 views

### How can I select two data points on line graph and return its corresponding values?

I have a simple line chart and I want to select any two data points of line and wants in return its corresponding value.
For example, my 11 different points are below. Simple line graph can be drawn ...

**0**

votes

**1**answer

32 views

### Combining 2 named ranges into a single series line chart in Excel 2010

How do I combine 2 named ranges into a single series. I have months on the X axis and average hours per month YTD on the Y axis. I want to separate the average hours into financial years i.e. the ...

**1**

vote

**1**answer

231 views

### Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed.
I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...

**0**

votes

**1**answer

26 views

### Formatting time s:mm.00 in Excel (Office 2010) and graphing

My son is a competitive swimmer. I would like to make a stacked bar chart using the various time standards for each stroke. The times are listed in m:ss.00 format. I have several problems I need help ...

**4**

votes

**1**answer

896 views

### How to make a LibreOffice Calc XY (scatter) plot with named dots?

I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456").
I would like to know if I could have the content of a ...

**0**

votes

**1**answer

310 views

### Stacked column chart in Excel with the label of x-axis between the bars

I want to draw a stacked column chart in Excel and I want to put the label of the x-axis between the bars; for example:

**3**

votes

**3**answers

94 views

### How to make Excel chart intelligently select data

I got a set of memory usage that I am trying to plot on Excel. I got time, total RAM, used RAM, used SWAP and free SWAP each with its own column.
But if I select all of columns for a line chart the ...