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

**0**

votes

**2**answers

3k views

### Adjust decimal separator in imported charts

I am about to write an English document with the German versions of MS Word and Excel. I use Excel to create a chart which I import into the Word document (by Copy & Paste).
I can tell Excel to ...

**0**

votes

**1**answer

533 views

### One dimensional charts in excel

I have 5 measurements (series) of six values going from 1 to 6.
So,
Series 1: 1.3;2.5;3.2;3.3;3.9;5
Series 2: 1.1;2.8;3.1;4.4;4.9;5.1
...
I would like to create a scatter chart where Y-axis would ...

**0**

votes

**0**answers

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

**0**

votes

**0**answers

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

**2**

votes

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**3**

votes

**2**answers

4k views

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

**0**

votes

**1**answer

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

**0**

votes

**0**answers

262 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

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

**-1**

votes

**2**answers

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

**1**

vote

**1**answer

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

**2**answers

177 views

### Excel bar graph, easy idea, hard implementation apparently

I want to make a graph like this, but I can't seem to make it correctly:
Data: 4, 2, 3, 4, 1, 3, 3, 2, 3, 4, 2, 3, 2, 1
Three elements: Y-axis potential values (1-4 or worst, below average, above ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

480 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

**0**answers

75 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**0**

votes

**1**answer

367 views

### Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks like this:
"timestamp","duration","ComputerName"
"7/8/2014 2:56:03 ...

**2**

votes

**2**answers

16k views

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

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

54 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

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

**0**

votes

**1**answer

748 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

318 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

900 views

### In microsoft excel 2013, how do you find where a data point would intersect with an already plotted line?

I have a graph with one series of data, with a trend line and an associated trend line equation (y = mx + b). I have another series of data, but only of y-values. I want to find the x-values of this ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

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

**1**

vote

**1**answer

66 views

### Using exported Google Play statistics in Excel

I have exported data from Google Play statistics, but I got this:
date,total_user_installs
20140618,291
20140617,291
20140616,291
20140615,290
20140614,289
20140613,289
20140612,288
20140611,286
...
...

**0**

votes

**1**answer

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

**0**

votes

**2**answers

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

**5**

votes

**3**answers

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

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

**-1**

votes

**1**answer

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

**3**

votes

**1**answer

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

**0**

votes

**1**answer

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

**2**

votes

**1**answer

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

**4**

votes

**2**answers

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

**0**

votes

**2**answers

54 views

### Having some issues making specific line charts in Excel

I need to pass a graph to excel and I'm failing to do so. I have no idea where to fix it.
Basically I already have one on Matlab, but I want to remake it from excel to make it look better. Here is ...

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

**1**

vote

**2**answers

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

792 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

**1**answer

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

413 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

961 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

187 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

705 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

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

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