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

**0**

votes

**1**answer

96 views

### Is there a way to have groupings of bars in a bar chart in?

I know this may be bad style, but I want a bar chart that groups certain bars together. For example if I was comparing the speed of two models of cars, and considering the speed under wet and dry ...

**0**

votes

**1**answer

6k views

### How to display series name inside bars of stacked bar chart?

I have a very busy stacked bar chart, some 20 or so series over time
I am not interested in the actual numbers, I just want to show the overall trend over time.
The default colours in Excel 2010 are ...

**2**

votes

**2**answers

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

**0**

votes

**1**answer

37 views

### Add a series to a chart by pasting its formula no longer works in Excel

I used to be able to add a new series to a chart by typing or pasting a =SERIES() formula into the formula bar when a chart's PlotArea was selected, as indicated here: ...

**0**

votes

**1**answer

75 views

### Icon size of OriginLab virtualised on Mavericks

I hope that someone can help me because I'm freaking out!
I just installed Origin 9.1 on a Mac (15 retina late 2013) using parallels 10 on Windows 8.1
Everything is fine, but, due to the high ...

**0**

votes

**0**answers

293 views

### Lines over data in Excel 2013 Scatter Graph

I'm having some problems getting the plot order in a Excel 2013 scatter plot right. One series should have markers ("raw data") which should appear below series with markers and line ("fit"). The ...

**0**

votes

**0**answers

24 views

### How to build a radar graph? [duplicate]

Does anyone know how to make a graph like this? Preferably in excel or using a simple online tool? There is similar on this web-site, but not exact. I need to have 4 sections, each containing 5-6 ...

**0**

votes

**0**answers

137 views

### Organization charts in Visio 2013

I am creating an org chart in Visio 2013 from an excel file . I have linked external data to shapes so I see the external data at the bottom of the screen. If I change the external data in excel and ...

**0**

votes

**1**answer

310 views

### Export figure as PDF with surrounding white space cropped out

I exported a chart from a Microsoft Excel spreadsheet by selecting the chart, the File > Export > Create PDF/XPS document, with the following options:
The result is nice except that:
How can I ...

**1**

vote

**1**answer

54 views

### Excel: Plot order total in map coordinates

I have a set of data that looks like this:
-X--Y----Amount-
AE 24 $178,00
Y 27 $162,00
AD 34 $680,00
AK 35 $178,00
Y 25 $29,00
U 23 $178,00
X 38 $193,00
AC 30 $226,00
AK ...

**0**

votes

**2**answers

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

363 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

525 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

116 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

764 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

193 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

355 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

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

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

215 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

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

582 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

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

156 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

80 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

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

423 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

67 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

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

**1**

vote

**2**answers

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

261 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

567 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

251 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

761 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

402 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

701 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

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

58 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

165 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

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

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

57 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

152 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

242 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

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

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

50 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

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