0
votes
1answer
25 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
2answers
37 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 ...
1
vote
2answers
173 views

How to get charts to automatically update with new data added?

If I were to have data in excel just like the table below, and then make line charts with that data. All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data. ...
0
votes
0answers
27 views

Excel scatter chart to show crossbar on selected point

Is there a way to configure Excel 2010 to show a crossbar on selected point in a scatter chart? The default behavior is to show a tooltip with the point's value when hover over the mouse cursor. When ...
0
votes
2answers
356 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.
1
vote
2answers
2k 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 ...
3
votes
1answer
7k 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. ...
0
votes
1answer
2k 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
2answers
2k 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
1answer
181 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% ...
0
votes
1answer
362 views

How do I stop Excel from showing a graph value which is different from the data?

My problem is that excel graphs are showing my data differently from the data that I'm using to plot it. From the example below, the purple line Ebay/Play etc. is being plotted, but from point 28, ...
3
votes
2answers
1k views

How can I format data bars based on value in Excel 2010?

I have a dataset containing values from 0 to 584. I would like to illustrate this using data bars, but I would like the databars to be green when the number is greater than 150, and red when the ...
1
vote
2answers
642 views

Excel 2010 column graph round percentage values to over than 100%

I have a graph showing percentages with a Data Table alongside. Excel 2010 rounds the values so that columns can sum to more than 100%, but I want every column in the graph to total exactly 100%. ...
1
vote
2answers
267 views

All cells in column as graph source except header

I want to create a graph of all values in a column, except the first which is a header. I could do this by selecting the following as Series X Values: =Foo!$A$2:$A$8 Problem is that I'd have to ...
0
votes
1answer
12k 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
3answers
290 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
vote
1answer
1k views

Bar chart in Excel 2010 with values over maximum

How can I make a chart like this in Excel 2010? Image from: EPA.gov I have data where two out of 20 values are disproportionately large. In order to create a useful chart I'd like to cut out a ...
7
votes
1answer
25k views

Create a pie chart from distinct values in one column by grouping data in Excel

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries). How can I make Excel group all the distinct values together and then display ...
1
vote
1answer
4k views

Excel: Charting date, time elapsed, and another value

I'm trying to chart growth in our nightly backups. The three values I'm using are the date of the backup, the backup job size in bytes, and the time the job took to completely in hh:mm:ss. Using ...
0
votes
1answer
104 views

Creating a graph for data in Excel

I am working on my thesis right now and am having trouble creating the right graph for my data. I have two conditions (1-public, 2-Montessori) and a set of values based on the score of the children ...
5
votes
2answers
21k views

How do I create custom axes in Excel?

I'm creating a "histogram" and need the values of "frequency" to be displayed in ascending or descending order, which means that I need custom values for the x-axis. Instead of having: 1 2 3 4 5 ...
0
votes
1answer
2k views

Excel 2010: Create Graph From List

I have created a drop down list for use in each row (for the purpose of categorising). I'd like to graph the selected data (i.e the column of drop down lists) into a graph, probably a pie chart. If I ...
0
votes
1answer
2k views

Excel 2010: How to color the area between charts?

I asked this question already on stackoverflow but it hasn't been answered yet. Instead I was advised to try it here, so here I go :) So there's that simple XY-Line-Chart in Excel (2010). It is ...
1
vote
2answers
1k views

Excel 2010, Consolidating Category Axis in Pie Chart

I am working on a very basic "home budget" spreadsheet, the goal of which is to quickly be able to see: A) how much money is left over after the bills are paid and B) what % of withdrawals are going ...
3
votes
1answer
13k views

Excel 2010: Can I hide columns without excluding the data from a graph?

In Excel 2010, is it possible to hide columns but still have the values show up in a graph? I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the ...
1
vote
2answers
357 views

Graphing connections per second in excel

I have an excel file like so: date time connections 2010-10-18 08:20:00 38 2010-10-18 08:20:01 71 2010-10-18 08:20:02 67 I want a line graph with the number of connections as the y axis ...
4
votes
3answers
64k views

how to add an average line to the graph in excel 2007 or 2010

In OpenOffice I'm getting trend-line and average-line properties by RightClick. But in Excel 2007 I see only trend-line. Same with Excel 2010. How do you make an average-line in Excel?