0
votes
1answer
24 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
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
2answers
54 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
vote
1answer
137 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 ...
1
vote
3answers
102 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 ...
1
vote
2answers
167 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
2answers
77 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/ ...
0
votes
1answer
95 views

What are the labels for minor ticks in a log scale graph?

What are the labels for the minor ticks in a log scale graph? I would like to label them. So, I want to know how to calculate the value for each of the minor tick.
2
votes
1answer
117 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 ...
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 ...
-1
votes
1answer
436 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 ...
0
votes
1answer
393 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 ...
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. ...
1
vote
1answer
773 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 ...
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 ...
2
votes
2answers
276 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
1answer
340 views

Constructing an annual cycle/radial diagram in PowerPoint

I would like to make a diagram like the below in PowerPoint, but I can't figure out how to draw the curved boxes (like the ones that say "Fishing" or "Trapping" in the chart). Diagram ...
0
votes
1answer
1k 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
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 ...
2
votes
0answers
544 views

How to make a LibreOffice Calc XY (scatter) plot with named dots?

I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456"). I would like to know if I could have the content of a ...
0
votes
0answers
61 views

Programs for reading data off interactive web charts

This question is in the same vein as this one: Program for reading data off scanned graphs Recently more and more interactive charts show up on the Net. Have a look at the following one: ...
2
votes
3answers
235 views

What tool to use to create a chart like this one? [closed]

Which tool can you recommend to draw such a diagram: I have tried Excel, but it is not really straight forward.
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
1k 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
2answers
2k views

How do I make the first row of an Excel chart be treated as a heading when it's a number?

Given a data sample like Prisoner 24601 0.50 Day 1 80 90 Day 2 81 89 Day 3 82 90 Day 4 81 91 What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather ...
0
votes
1answer
1k 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) ...
2
votes
1answer
158 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 ...
2
votes
1answer
1k views

Any alternatives to Ubigraph?

Ubigraph is a different way to create interactive user interfaces with the purpose of visualizing huge amounts of data. Its visualizations are simply stunning. The problem is that the project seems ...
1
vote
2answers
2k 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 ...
4
votes
3answers
22k 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 ...
2
votes
2answers
2k 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
2k 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 ...
0
votes
3answers
2k views

Relative Gantt in MS project?

Is there a way to create a relative Gantt in MS project, that is a Gantt that doesn't have a defined start date, just amount of time required for each task?
1
vote
1answer
6k views

Why can't I add a trendline to a chart in Excel 2007?

I created a really simple chart based on 2 columns (date and numeric value). I click on the chart, go to Chart Tools/Layout. The Trendline drop down is greyed out. What am I missing?
2
votes
2answers
5k views

Excel - graphing mean and standard deviation

I have measurements for multiple devices, and have their mean and sd values. I would like to produce a chart that would show these values, and I think the best would be if I could have something that ...
2
votes
4answers
4k views

Excel: How to make bar graph shorter for higher numbers?

I would like to inverse the bar graph in a way that the lower the number, the higher the bargraph should be. Currently in the picture below, those items ranked 200 have the highest bar height while ...
3
votes
5answers
328 views

Excel graphs/charts: any good 'how to…' resources out there?

Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts? I've reached the point where I need to do more than tables. ...
2
votes
2answers
8k views

Program for reading data off scanned graphs [closed]

I know such thing exists, cause I used it somewhat long ago ... problem being I cannot remember what it's called. I have some graphs from which I need to read off points (numeric values). The graphs ...
0
votes
1answer
882 views

Product sales chart in Excel, from data in Access

I have a table in an Excel 2007 worksheet containing details of orders (note: I have manually changed the details to be fake on everything) I want to count the number of products ordered for a ...
0
votes
7answers
13k views

Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following: The x-axis has the wrong scale - it should range from about $3000 to ...
1
vote
4answers
153 views

Any good online chart generators? [closed]

I am looking for some free site that allows you to easily create a chart from provided data (in interactive mode, so I don't have to write any code) and export it to an image. Can anyone recommend ...