Tagged Questions
0
votes
1answer
27 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
2answers
23 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
1answer
39 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 ...
1
vote
1answer
36 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 ...
0
votes
0answers
87 views
How to graph events per time in excel (from log file)
I have a log file in the following format:
A | B | C | D
DD.MM.YYYY|HH:MM:SS|DEVICE|EVENT DESCRIPTION
what I want to do is, create a graph with the time on the x-axis and the events ...
2
votes
2answers
131 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
1answer
163 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
2answers
297 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
1answer
177 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
2answers
45 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
1answer
166 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
1answer
296 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 ...
0
votes
1answer
425 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
2answers
605 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
2answers
1k 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
1answer
108 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
1answer
220 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
2answers
5k 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
1answer
101 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
0answers
282 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
4answers
1k 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
2answers
257 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
0answers
63 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
1answer
5k 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
2answers
200 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
1answer
116 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
1answer
744 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 ...
1
vote
1answer
515 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 ...
0
votes
1answer
1k views
Rotating SmartArt or charts in MS PowerPoint or Excel
How do I rotate (90 degrees) a SmartArt Graphic or chart in Microsoft PowerPoint or Excel?
I'm trying to show rotating spheres that when lined up, provide a topic for an intro, body and conclusion ...
3
votes
1answer
9k 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
2k 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 ...
1
vote
1answer
626 views
How to plot disproportionate values in single graph with Excel
I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One ...
0
votes
1answer
708 views
Create progress bar or milestone type graphs in Excel 2007
I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...
3
votes
1answer
126 views
Labelling points in a plot in Excel with customized label
I want to label a plot's points in excel with neither the x nor the y variable but a label that is in a cell where the row happens to be. So for example, if I have the following table data:
1 1 a
...
5
votes
4answers
10k views
How can I save a graph to a PNG or GIF file in Microsoft Excel?
How can I save a graph to a PNG or GIF file in Microsoft Excel?
I know I can save as an HTML file and use the image created there, but I suspect there is a way that doesn't create other clutter of ...
0
votes
1answer
541 views
excel - how to connect a graph max with original (0,0) point
If I have a spreadsheet that has the following data:
A
0 0
1 2
2 4
3 4
4 6
0-4 X Axis
A is Y Axis
First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
...
3
votes
3answers
632 views
How to visualize/graph a massive dataset?
I have a CSV file of data collected using Performance Monitor. It collected CPU usage at 5 second intervals for two weeks.
I need to be able to graph or visual the data in a way that'll help me ...
2
votes
1answer
135 views
I would like the dates to appear on the X-axis and the colour category to apear on the Y-axis, Excel
There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...
1
vote
2answers
780 views
Excel: How to create a chart that automatically scales the axis
I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.
The values are the following:
A: 412 684 944 2009 9601
B: 7813,4 10377,6 11138,8 16216 ...
1
vote
3answers
7k views
Excel: making line charts so the line goes through all data points
I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around?
I've ...
0
votes
3answers
910 views
Annotating Graphs From Textual Data
I've got a graph that was generated from a data set that contains:
(date, value, annotation)
The annotation is a constant value [its either there or is blank] and I would like to add in the third ...
0
votes
1answer
488 views
How can I prepare a cake graph in excel with a result based on 100%?
I need to distribute correctly a little data in an excel graph.
I have the total I've earned last year which should represent the 100% of the cake.
Then I have my insurance expenses and I want to ...
0
votes
1answer
1k 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 ...
1
vote
4answers
7k views
How to create a Wind Rose plot in Excel 2007?
I am attempting to create a wind rose graph, i.e.
My data is wind speed and cardinal wind direction in separate columns:
Wind (mph) Wind Direction
3.66 SE
2.69 SE
2.62 SW
...
1
vote
2answers
823 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 ...
0
votes
1answer
256 views
How to create graphs in Excel 2007?
I have data in CSV format, and I want to create a few graphs. I was looking around in google for how to do that, but it seems like most help about Excel graphs does not match my version of Excel ...
2
votes
1answer
6k 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
1answer
559 views
Excel graph: turn stacked bar chart into part bullet chart
I've a simple data file that has one column of actuals and another of target against categories. I would like to turn the TARGET figure into a 'Bullet marker'. I've seen it done on other graphs but ...
1
vote
2answers
1k views
Calculate the Y Axis interval for a chart
When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval?
I've been looking at Excel which seems to choose nice intervals like ...
3
votes
3answers
1k views
Excel Graph: how can I show two values in the same bar? Not using stacked?
I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...
