# Tagged Questions

**0**

votes

**0**answers

33 views

### Excel: How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days.
Now, I draw this notes ...

**1**

vote

**1**answer

33 views

### Excel Scatter Diagram

I have data in Excel as follows (just example of them, not all):
Name | Asset | Count
-----------------------------
John | Apple | 1
Adam | Banana | 2
Pete | Apple | 1
Mark | Berry ...

**2**

votes

**1**answer

46 views

### Create graph for requests per minute and uri

I have a table that looks like this.
time|uri
08:50:28|foo
08:51:42|bar
08:52:48|foo
08:53:49|bar
08:53:50|baz
08:54:02|bar
08:54:03|baz
08:55:27|foo
08:55:34|baz
08:56:47|bar
I would like to make ...

**2**

votes

**1**answer

94 views

### Excel make two or more graphs have the same scale

I have several area graphs in an Excel spreadsheet. I want all of those graphs to have exactly the same scale.
Each of the graphs have a measurement in meters on each of the axes. I want each of the ...

**0**

votes

**2**answers

160 views

### Excel 2010 line chart; limiting data points to fewer than the max

In Excel 2010, how do I limit the number of data points on a line graph to the latest (or last) 4 data?
I update the spreadsheet often, but only the latest data is graphed and reported.

**0**

votes

**1**answer

31 views

### Excel graph showing customer representation based on size of different businesses

I would like to represent in a graph the percentage of A, B and C customers in each business unit, taking into account the size of the BU (on the X axis).
Sales % A % B % C
...

**1**

vote

**2**answers

1k views

### Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text ...

**0**

votes

**0**answers

41 views

### Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...

**-1**

votes

**1**answer

157 views

### Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this:
It might ...

**-2**

votes

**0**answers

80 views

### Get series values on condiation, excel [closed]

I have following data in my XLS -
8:35:01 NZLOAD app read: 2000005 01:03.0
8:35:03 Pending app INSERT 0 00:00.8
8:35:14 T4 app INSERT 1944132 00:09.6
8:35:47 NZLOAD app read: 2000005 ...

**0**

votes

**1**answer

67 views

### Calculating Range coverage

I'm putting together a sheet that includes two data columns, 'Min Value' and 'Max Value'. All values between Min and Max values are consider the 'Range' of each entry. The goal of the sheet is to ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

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

**1**

vote

**1**answer

494 views

### Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...

**0**

votes

**1**answer

926 views

### How to show an additional single point on a line graph in Excel?

I have a data set which shows the "efficient frontier" curve and a data point showing the decision made. I wish to have the data point be plotted in relation to the frontier but as an isolated point ...

**1**

vote

**2**answers

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

**0**

votes

**1**answer

792 views

### Solving a linear equation with excel

Sorry if this is the wrong place to ask (Meta says it's the right place but you never know) but I'm really struggling with finding a simple answer to this.
I'm using Excel 2011 for Mac, and want it ...

**1**

vote

**3**answers

3k views

### Plot cumulative data in Excel

Is it possible to plot data in excel without having to define the function of the data in an extra column?
Think of this simplified example:
There are two columns with numbers A and B. Is it ...

**0**

votes

**0**answers

26 views

### How can I create a “spectrum” graph in Excel? [duplicate]

I'm currently performing some data analysis, I would like to create a "spectrum" graph like the link below to indicate the distribution of some special data occurred over a series of events. (I don't ...

**0**

votes

**1**answer

99 views

### Line Graph Adding Value of Series 1 to Series 2

I'm working on a line graph that contains two lines (each representing two different sets of data) with percentage values for each time period. In the first time period, the value for Set A is 3% ...

**2**

votes

**2**answers

240 views

### Drawing sample points versus time in Excel

I have a set of data as follow:
As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time.
I need to present this in a chart (I ...

**2**

votes

**1**answer

61 views

### Having trouble creating certain graph in Excel

I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal.
But when I try to recreate ...

**0**

votes

**2**answers

433 views

### Line Graph with Date on X axis and occurrence on X axis - Excel

I am trying to produce a Line graph that shows the number of access requests over a given time period to my server.
The log data is like so:
10/05/2013
10/05/2013
10/05/2013
11/05/2013
11/05/2013
...

**0**

votes

**1**answer

504 views

### Excel: create a graph with “string” value and not numbers

I need to create a graph in Excel that takes the values from a table that describes the products with words like "low", "middle low", "middle high", "high"; and I need that on the graph appear those ...

**0**

votes

**1**answer

259 views

### Creating multiple plot per level of factor (trillis graph) in excel

Is there way to automate the process to make graphs like the following (also known as trallis graph) in excel ? I know there are some R interface with Excel (some of them need to be purchased), but I ...

**1**

vote

**1**answer

91 views

### combining two plot type in excel

I want to combine xyline plot with bar plot in excel.
I created xyline plot and then added new series with a hope that I can chance the series 1 later.
Step1: But it turned to be not true, see the ...

**2**

votes

**2**answers

596 views

### How to create an Excel chart showing a value and its change?

I would like to create a chart that shows a value and how it has changed, like this one in Excel.
The importatnt thing (which I am not able to achive) is that there are two numers associated with ...

**0**

votes

**1**answer

793 views

### Excel scatter graph fill inside shape

I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart ...

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

894 views

### Lines over data in Excel 2007 Scatter Graph

I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second ...

**1**

vote

**2**answers

79 views

### Excel: How is this graph even possible?

I made a line graph using two sets of data:
However, the blue line is totally out of place somehow and I have no idea why. I feel like I've checked everything. What could be going wrong?

**1**

vote

**1**answer

399 views

### Excel 2007: plot data points not on an axis/ force linear x-incrementation without altering integrity of non-linear data

In Excel, how does one go about plotting points that don't have an x component that is an x-axis label?
For example, in my graph, the x-components are derived from the cosine function and aren't ...

**1**

vote

**1**answer

655 views

### How to plot 3D graphs in Excel from CSV data?

I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one ...

**1**

vote

**1**answer

1k views

### how to extract data from an image graph

I'm looking to get that from a graph. but problem is that graph is in image form. Now I want to extract data in excel from that graph. how can i do it? I'm using office 2003.

**0**

votes

**2**answers

1k views

### Excel Line Graph with columns and rows transposed

My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B ...

**1**

vote

**2**answers

2k views

### Excel graph - two lines, one axis with date

I want to make Excel chart that shows my accounts' balances in time.
I have 2 bank accounts and I have all transactions saved in Excel. The data's format is:
Column A Column B Column C Column ...

**0**

votes

**1**answer

149 views

### Excel Different line graph loaded on each selection

I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, ...

**0**

votes

**1**answer

274 views

### Excel per-point custom error bars

I am attempting to draw error bars on a multiple bar graph in Excel 2007, and I am having trouble with the custom error bar minimum value. First, I created the graph from multiple series, then I ...

**1**

vote

**2**answers

12k views

### Easily Plotting Multiple Data Series in Excel

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...

**0**

votes

**1**answer

136 views

### Formula in Excel graph

I am creating a line graph in Excel 2007. What I would like to achieve is to specify a formula in the chart data range.
What I have now in the chart data range is:
...

**1**

vote

**0**answers

404 views

### Create line graph with embedded horizontal histogram

How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.

**0**

votes

**4**answers

2k views

### Excel - Smooth a curve by calculating / interpolating source missing values

I have a table of values like this one :
18
18
18
46
46
46
46
46
57
57
57
57
57
57
69
69
69
69
69
69
64
64
64
64
64
64
56
56
56
48
48
48
44
or if you prefer :
18
0
0
46
0
0
0
0
57
0
0
0
0
0
69
0
0
...

**2**

votes

**2**answers

342 views

### Excel auto Gantt chart

I have a spreadsheet with 4 columns. Teachers, Class Taught, Class Start (date), Class End (date). I need to plot this in excel somehow to show what days of the month are booked by each teacher.
I1 ...

**1**

vote

**0**answers

64 views

### Keep values for grouped or hidden cells in graph? [duplicate]

Possible Duplicate:
Excel 2010: Can I hide columns without excluding the data from a graph?
I have a graph based on data contained in cell columns that can be grouped. Whenever I collapse ...

**0**

votes

**1**answer

10k views

### How to graph 3 different lines in the same graph with Excel?

I want to draw 3 line graphs on the same graph (to compare the data). They share the same x axis, and use the same data for the y axis but with different values. How can I do this? It's not working ...

**3**

votes

**3**answers

272 views

### How make this graph in Excel?

I'm trying to do this kind of graph in Excel, but nothing so far.
I don't find anything like it, but it has to be this way, not bars.
starter 22,58 20,76 7,1 37,93 68,42
professional ...

**-1**

votes

**1**answer

126 views

### Excel 2007 plot with labeled data items

I have data in the following format, where each label defines a row of data:
label1 x1 y1
label1 x2 y2
label1 x3 y3
label2 x1 y1
label2 x2 y2
label2 x3 y3
This is a very large data ...

**0**

votes

**1**answer

1k views

### Excel x-axis scale [duplicate]

Possible Duplicate:
Excel axis problem
I jumped from an older version of Excel to the new ribbon interface and am stumped trying to make a simple graph.
I have a set of pair values that go ...

**0**

votes

**0**answers

505 views

### Excel 2007 adding mean value and variance to histogram

I have to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range).
Example:
Data:
a,b,c,d,...
...

**1**

vote

**1**answer

740 views

### Record CPU usage then create Excel line chart with “Series” Column

I need to create a line chart to display the cpu usage of each process over time. How do I create the chart with time as the X axis, %CPU as the Y axis, then use the command name to indicate which ...