# Tagged Questions

**1**

vote

**1**answer

18 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

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

26 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

18 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

**0**answers

13 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

38 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

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

**0**

votes

**1**answer

42 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

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

**-1**

votes

**0**answers

15 views

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

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.
Description: Hai, I was tried to plot a graph having two fields (NAME and Gradde like ...

**0**

votes

**1**answer

34 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

68 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

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

24 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

66 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

282 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

101 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

42 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

69 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

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

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

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

**2**

votes

**3**answers

89 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

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

**3**

votes

**1**answer

55 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

60 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

506 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

157 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

35 views

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

I am sorry if this is a dumb question, but 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 ...

**0**

votes

**2**answers

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

votes

**1**answer

254 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

85 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

203 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

39 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

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

**1**

vote

**1**answer

192 views

### How can I set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

I was wondering if there was a way I can 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 ...

**2**

votes

**0**answers

95 views

### Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows
Mean values 61 43
Sample 1 0.009 0.059
Sample 2 0.108 0.099
Sample 3 0.043 0.038
...

**1**

vote

**1**answer

739 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

**0**answers

19 views

### Excel scatter plot with labels [duplicate]

I need to make an excel scatter plot.
Col A = Names
Col B = X axis
Col C = Y Axis
Doing a scatterplot on B,C makes the right chart.
However, how do I add little labels to each point with the ...

**1**

vote

**3**answers

116 views

### How to create a Horizon Graph in Excel?

I was wondering if anyone knew how to create a Horizon Graph in Excel (preferably without needing to download an Add-In)? I believe these were originally called, "two-tone pseudo charts" developed by ...

**0**

votes

**0**answers

33 views

### How to plot excel chart with multiple series from single data source

How do I plot the following multiple series information on a single chart:
DateTime SeriesName Duration
2014-05-02_10:21:21 X 2013.006
2014-05-02_10:21:22 Y ...

**0**

votes

**2**answers

92 views

### Superscripts in Excel chart labels

I have data like this:
2 | 5
4 | 6
8 | 7
I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...

**1**

vote

**2**answers

51 views

### How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like:
5/29/2011
6/21/2011
6/26/2011
7/1/2011
7/3/2011
...

**0**

votes

**1**answer

115 views

### How do I group and chart date ranges in Excel?

I want to visualize the use of vehicles in a family through time. I have collected the dates each vehicle was being used as follows (example data) :
And want to somehow chart the data to visualize ...

**1**

vote

**1**answer

116 views

### How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where:
Column A is filled with arbitrary dates sorted by increasing age
Column F has numeric data relevant to this question
Row 1 is the ...

**3**

votes

**2**answers

45 views

### Automatically updating bar chart?

So for a project at work I have a table in excel that contains numbers for each month of the year up to this one in four categories. It looks (a bit) like this:
...

**2**

votes

**0**answers

61 views

### Automatic scatter plot in Excel 2010 [closed]

I have two quite large data sets of which I want to plot every line in one plot.
The pattern is the following:
x-axis: Set one (Colonne 1-6)
y-axis: Set two (Colonne 1-6)
Now I want such a plot for ...