Help on questions about graphs, charts and other graphical methods to show data.

**0**

votes

**2**answers

1k views

### How do I create a chart in Excel with dynamic series based on the data content?

How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set:
Date Series A Values
...

**1**

vote

**1**answer

63 views

### How can I generate a dotplot of general files?

On a few occasions I've seen some papers that apply bioinformatics dotplots (aka recurrence plots) to general files, to demonstrate things like beat detection in music, or relationships between .dll ...

**1**

vote

**2**answers

2k views

### Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0.
I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10:
30, 20, 10, 0, -10, -20, -30
I have set set ...

**7**

votes

**1**answer

27k views

### Create a pie chart from distinct values in one column by grouping data in Excel

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).
How can I make Excel group all the distinct values together and then display ...

**0**

votes

**7**answers

14k views

### Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following:
The x-axis has the wrong scale - it should range from about $3000 to ...

**0**

votes

**1**answer

888 views

### Product sales chart in Excel, from data in Access

I have a table in an Excel 2007 worksheet containing details of orders (note: I have manually changed the details to be fake on everything)
I want to count the number of products ordered for a ...

**1**

vote

**1**answer

1k views

**1**

vote

**2**answers

2k views

### Distribution of values as a graph in excel

I have a set of 1-D data (0,0,0,1,2,1,1,5,6,1,1,100,1,etc) and I'd like to generate a graph from it that shows the number of values in a set of ranges. I.e
0 - 3
1-7 - 8
8-30 - 0
30+ - 1
The data ...

**3**

votes

**5**answers

50k views

### Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this:
2007 2006 2005
Amount 300 200 100
I want to create a graph of the time series that looks ...

**0**

votes

**0**answers

16 views

### Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data:
-0.0892 8
-0.0711 16
-0.0529 19
-0.0348 13
-0.0166 5
0.0015 12
0.0197 5
0.0378 5
0.0560 3
0.0741 4
0.0923 5
0.1104 1
I would like to add a ...

**1**

vote

**1**answer

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

**3**answers

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

**0**

votes

**1**answer

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

**1**answer

122 views

### Visio 2010 Organization chart

I'm looking to build an org chart in Visio 2010 by using data from excel. There are many tutorials about this, so this part is pretty easy.
My question is, is there a way to create automatic ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**0**answers

24 views

### Plot 3 y axis in excel

I'm trying to plot three axes on the same graph. My data headings are: date/time (x axis), water level, temp, trout up, trout down.
I've seen examples where this is possible but don't know how to do ...

**0**

votes

**1**answer

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

**0**

votes

**0**answers

9 views

### How to format the number category in chart tags?

Hello fellow Excel users:
I have 3 desktops at home. One has Excel 2007, other one Excel 2010, and the last one Excel 2013.
As a heavy Excel user, I prefer to have 3 different versions in order to ...

**1**

vote

**1**answer

27 views

### Adjacent bar charts with different scalings

I have this chart created in Excel 2013:
using this data:
Last 4 Weeks Last 12 Months
No. of Accounts 36 186
Net Revenue 149,562 ...

**0**

votes

**0**answers

19 views

### Excel 2010, how to show percentage values on clustered columns chart?

I was looking for a better way to do this but no luck googling. My problem is about showing numeric values and percentage value in clustered column chart. When I use pie chart, there is an option to ...

**0**

votes

**1**answer

3k views

### Excel scatter chart, with grouped text values on the X axis

Apples 1
Apples 5
Apples 2
Bananas 1
Bananas 4
Bananas 6
I want two bars on the X axis (Apples, Bananas), but with crosses marking the points on the Y axis.
Here's a mockup:
I'd want 1 ...

**0**

votes

**0**answers

16 views

### conditional formatting of pie chart segments

i have a very simple pie chart - developed in excel for mac 2011.
each segment of the chart represents a 'group' and is sized relative to a column of data called 'count'. there is a second column ...

**1**

vote

**1**answer

41 views

### Excel chart colours

In Microsoft Excel 2010, when I insert a chart with multiple data series (or a pie chart), each series (or slice) is automatically given a colour. My 2 questions are:
What is the formula used to ...

**2**

votes

**1**answer

46 views

### How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this:
30.5.2014 700,80 CZK
6.6.2014 1 000,30 CZK
20.6.2014 ...

**1**

vote

**1**answer

793 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

**1**answer

3k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

**1**

vote

**1**answer

8k views

### Plot 2d graph in Excel

I have data in three columns, one for the x axis, one for the y axis and one actual data as:
X Y Value
0 0 1,005155
0 1 2,051385
0 2 1,15305
...
1 0 1,112285
1 1 1,48512
1 2 ...

**0**

votes

**1**answer

45 views

### Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this...
The desired ...

**-1**

votes

**2**answers

73 views

### how to create excel charts having strings in both x and y axis

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.

**0**

votes

**0**answers

44 views

### Embedded excel chart in powerpoint does not print correctly from Office 2013

We have a user that has Office 2013 installed in her machine - she is the only one. The rest of the users have Office 2010. The user with 2013 is the only one with the issue.
There is a powerpoint ...

**0**

votes

**1**answer

39 views

### How to shade the area under a straight line graph in Excel

How do I shade the area under a straight line graph in Excel, along the x-axis? The graph data points are shown below.
0-16.67
170-16.67
170-6.712
187.5-6.712
652-25.352
670-33.408
910-33.408
910-0
...

**0**

votes

**0**answers

24 views

### Excel 2013 Chart - Multiple Series on Pivot Chart

I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type.
The ...

**0**

votes

**1**answer

32 views

### Excel chart axis with personal label instead of number

I'm a simpleton with excel but writing a research dissertation. Much charting involved...
My y axis has values 0-6 but each number represents a patient response (for example never, very rarely, ...

**-1**

votes

**1**answer

26 views

### How do you shift data markers in excel?

How do you shift the data markers such that they align with the end of the month? The chart is shown here.

**0**

votes

**1**answer

22 views

### Chart not showing all data

I have created a very simple spreadsheet with data by half an hour for every day from Mon - Fri.
I have then created a line chart and in the legend every day is shown, however the data for Monday is ...

**1**

vote

**1**answer

70 views

### How to plot complex data as a radar chart in MS Excel?

I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a ...

**1**

vote

**2**answers

323 views

### How do I disable screen updating while reformatting an Excel 2007 chart?

I have a chart with about 70,000 data points. When I format the axes or data series, Excel automatically updates the chart before I am finished editing the value. This is very slow (1+ minutes), even ...

**1**

vote

**2**answers

313 views

### Excel: How to Superimpose 2 Stacked Column Charts

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...

**1**

vote

**0**answers

29 views

### Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right.
I have a Workbook.Open routine which will change to custom formatting (and back on ...

**2**

votes

**1**answer

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

**3**

votes

**1**answer

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

**0**

votes

**1**answer

70 views

### Creating pie chart template for dynamic data

I am trying to create a pie chart template so that i can write data source dynamically through my java program and template will create the chart once after the data is added.
Please refer the example ...

**0**

votes

**1**answer

46 views

### Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application.
Below is the example of code that I'm ...

**0**

votes

**1**answer

81 views

### Pie Radar Chart outline series not working

I have been trying to create a Pie Radar Chart as described in answer to this question.
Everything works until I get to the section that describes inserting a series to create the chart's outline:
...

**2**

votes

**3**answers

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

**1**

vote

**1**answer

37 views

### LibreOffice graph axis label

I have made a graph out of about 20 lines of dates and 20 lines of values, but the graph doesn't show all the dates, which really bugs me, it just shows 'month' difference:
I would like to have ...

**0**

votes

**1**answer

32 views

### Microsoft Excel chart with dynamic series

I am working on creating a excel template file that includes charts generated from the data added. One of the charts displays trending data over 12 months for an unknown number of products. The ...

**2**

votes

**1**answer

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

**-1**

votes

**1**answer

28 views

### Plot multiple sets of x,y data on a single chart

Have several series of data I want to plot on the same chart:
Series A
Y X
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 ...