# Tagged Questions

**-1**

votes

**0**answers

14 views

### How can I use 2 information on 1 Y axis graph?

please help. I want to create a column bar graph that shows 2 information, one is the actual number and another is the annualized number. Can it be stacked but with different style (the annualized ...

**0**

votes

**0**answers

26 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

13 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

18 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

37 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

15 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

30 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

21 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

16 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

41 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

126 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

27 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

87 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

27 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

42 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

50 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

28 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

26 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

47 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

25 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

46 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

40 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

238 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

122 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

34 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

51 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

119 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

75 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

110 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

32 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

78 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

130 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

61 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

**0**answers

244 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

101 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

27 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

76 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

45 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

89 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

86 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

43 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

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

**0**

votes

**1**answer

66 views

### How to create line chart in Excel with two series of ordinal/nominal data?

I have these two columns in Excel.
Result Speed
------ ----
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
MEDIUM HIGH
HIGH HIGH
HIGH HIGH
HIGH ...

**2**

votes

**1**answer

126 views

### How to make Excel chart axis start NOT at major unit?

Is it possible to have an Excel chart where the axis does NOT start at the major unit?
See the example below, where I want the x-axis to start at the year 2007, but have major unit 5 years and show ...

**1**

vote

**2**answers

71 views

### How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises.
Here is the data:
...

**0**

votes

**1**answer

87 views

### Excel Chart from Multiple Sheets

I have a bunch of sheets and each one has a value in cell K15 and call K20. How do I make a stacked column chart that shows these values stacked for each sheet?
Forgive my crude drawing, but ...

**-1**

votes

**1**answer

36 views

### How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart:
I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...

**0**

votes

**1**answer

76 views

### Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this:
2014-02-20 23:04:57.9263690 +00:00
2014-02-20 23:05:02.3117944 +00:00
2014-02-20 23:05:02.7490564 ...

**1**

vote

**1**answer

259 views

### How do I link to excel chart data in PowerPoint with relative paths?

This question is similar to the question posted in
How do I embed video in PowerPoint with relative paths?
But in my case I search for an answer to get Excel charts, which are linked in an absolute ...