Graphs, charts and other graphical methods for showing data and their relationships.

learn more… | top users | synonyms (3)

2
votes
1answer
170 views

Make dates appear on the X-axis and the color category appear on the Y-axis

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 10/...
2
votes
2answers
131 views

Represent in a diagram how much work remains

I have a project consisting in 3 tasks. First Task (T1) is done at 10%; Second Task (T2) - at 50%; Third Task (T3) - at 75%; I need to represent it in a diagram: how many work remains to do for ...
2
votes
2answers
254 views

Processing RAW data to make a web displayable graph

I have data on a Linux system, about 44K data points, that I'd like to make a Scatter plot. The plot should be saved so that it can be displayed on a website (JPG?). Some other parameters: X-Axis: ...
2
votes
1answer
1k views

How do you set a variable Y-axis min/max?

I have a colleague who creates lots of charts. He wants the min/max of the Y-axis of a bar chart to reflect the min/max within a range in Column "A" of an Excel spreadsheet. The min/max will change ...
2
votes
2answers
1k views

Visualizing document citations in a graph

Is there any tool which draws a citation graph for a group of related papers? (it doesn't matter the format of papers - PDF, Word, etc - it also doesn't matter if the software doesn't perform parsing ...
2
votes
0answers
76 views

How to interpolate a graph with multiple series in Excel?

I have a X-Y scatter plot in Excel 2007 with multiple lines on same plot like a series for 2%, and other series for 3% and 5%. How can I interpolate such data? For example, if I want to know a value ...
2
votes
1answer
46 views

Pie chart in Excel 2010 is not reading/displaying the number 0

I am trying to create a very basic pie chart in Excel with the following data: Score Quantity 0 5 1 5 2 6 3 3 4 4 5 ...
2
votes
2answers
168 views

How to duplicate the Y-axis label of a chart to the other side

I have this chart in Excel with the Y-axis automatically placed on the left side of the chart. Aside from inserting a textbox, is there any other way to duplicate that label to the other side or to ...
2
votes
0answers
40 views

How to set a non-linear Y axis on a graph in Word?

I need draw the chart similar type with the chart below but I don't know how to set up the Y axis value and resize to view as this.
2
votes
0answers
49 views

Legend-placement in two different charts is different with same settings

I have two charts, and in both of them I want I want to place the legend in the upper right corner of the chart-area like so: However when attempting to add a legend to the second chart, it is ...
2
votes
1answer
2k views

Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...
2
votes
1answer
318 views

Creating a line graph in excel with changing/result cells

For a project we are creating care packages for the homeless. I am trying to figure how many kits to make for the least leftover material as the things we are putting into the packages are sold in ...
2
votes
1answer
30 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
2
votes
1answer
293 views

Data retention on storage devices?

Is there any official table out there that shows how many years can a storage device retain data before it becomes unreadable? Storage devices: USB memory sticks, classic hard drives, SSDs, optical ...
2
votes
1answer
1k views

how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales. First data set displays fine (left Y axis scale) Second data set displays fine (right Y axis scale) However when I try to ...
2
votes
0answers
2k 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 ...
2
votes
0answers
120 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 ...
2
votes
1answer
1k views

Color bands in bar charts in Microsoft Excel 2010

Is it possible to obtain a bar chart like the one in this example: (that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.) Any ideas?
2
votes
1answer
61 views

X-axis changes Excel plot output

I have the following Excel file: https://dl.dropboxusercontent.com/u/33532467/GDV_Prognose_Leben.xlsx The green hatched area is not shown properly. I would expect: The horizontal axis seems to ...
2
votes
0answers
155 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each report,...
2
votes
0answers
100 views

Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its place....
2
votes
0answers
307 views

MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation

I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...
2
votes
1answer
930 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   &...
2
votes
1answer
211 views

Custom area graph in Excel (or google spreadsheet)

I am trying to visualize my loans with area graph and have some additional needs/wishes. For example - this is my data (made up): house car mower vacation diners ...
2
votes
1answer
2k views

Application to generate graphs from MySQL table

I am looking for a solution to generate graphs from MySQL tables (local MySQL server). I would like it to work on Windows, and not be based on a server (like a PHP server). This is just basic stuff: ...
2
votes
1answer
5k 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 ...
1
vote
2answers
2k views

Distribution of values as a graph in excel

I have a set of 1-D data (0,0,0,1,2,1,1,5,6,1,1,100,1,etc) and I'd like to generate a graph from it that shows the number of values in a set of ranges. I.e 0 - 3 1-7 - 8 8-30 - 0 30+ - 1 The data ...
1
vote
2answers
95 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
5answers
669 views

Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact) code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5 Every day I ...
1
vote
1answer
5k views

How to draw an excel chart from two columns?

Consider the following table: 1970 - 4705 1980 - 4771 1990 - 4998 2000 - 5181 2001 - 5195 2002 - 5205 The left number is x, the right is f(x). (The numbers are in separate excel columns) I need to ...
1
vote
2answers
5k views

Line Graph with Date on X axis and occurrence on X axis

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 ...
1
vote
4answers
262 views

Manually adjust axis numbering on Excel chart

I want to adjust the X axis of my scatter diagram according to my diagram points in MS-Excel 2010. I have seen in some guides that I can change it by editing the "Axis Labels" in "Select Data". As you ...
1
vote
2answers
15k 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
2answers
13k 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. ...
1
vote
1answer
2k 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 ...
1
vote
4answers
6k views

Best tool for creating organizational charts? [duplicate]

Possible Duplicate: Application to help build diagrams I need to find a Windows tool/software, or an online service, for creating organizational chart for the company I'm employed at. I have ...
1
vote
5answers
23k 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 2....
1
vote
2answers
236 views

What software created this graph?

Can anyone recognize what software could have been used to create a graph like this? I'm looking for something that could produce the same type of arrows.
1
vote
1answer
8k views

Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form: X | Y ----+----- 3 | 42 4 | 57 6 | 92 11 | 119 19 | 316 (NOTE: The above table is made-up data) What I'd like to do with MS-Excel is to plot 2 ...
1
vote
1answer
4k views

Time units and automatic formatting of the y-axis in Excel

I have a chart with time values on the vertical (Y) axis. As the values can change a lot the formatting of the axis minor and major units is automatic. The problem is that Excel chooses values which ...
1
vote
2answers
800 views

Looking for PHP memory/CPU graph generator [closed]

Basically, that's what I'm looking for. I want an app that makes a live graph of the server's CPU and RAM usage. Is there anything like this?
1
vote
2answers
17k views

Symbols in Excel graphs [closed]

I am a scientist and would like to use Excel to graph data. I know many people who use Excel graphing. However, Excel graphing will not let you use symbols in the Titles, in the axes labels, or in ...
1
vote
1answer
319 views

Pie Chart in Excel

I tried to google this but no luck. It is easy to add a pie chart when you have prcentace data but what if you just have a list of partially repeated data? For simplicity imagine there is a table in ...
1
vote
3answers
573 views

Creating Flowcharts in the Office Suite

I need to create a couple of flowcharts and I am wondering which of the Microsft Office products are best suited to doing so (Word, Powerpoint, Excel?). Do any/all of these have flowchart creation ...
1
vote
1answer
63 views

Creating a pie chart illustrating a column of values in Numbers or Excel

I have a checklist of songs, where one column represents each song's tempo. I'd like to create a pie chart that shows the total number of slow songs, medium-tempo songs and up-tempo songs. Creating a ...
1
vote
1answer
236 views

Excel: Get rid of gaps in line chart

I have a table that contains the data with some absent values. If I create a line chart for that, there are gaps in place of absent values, but I'd like to have the line just follow through to the ...
1
vote
2answers
62 views

Excel data layout

I'm wanting to make a chart similar to this: The data i'm working with is different but the concept should be the same. I'm most curious in how to group x-axis (category) values. In my case I will ...
1
vote
1answer
2k views

A chart where the line between points does not interpolate

I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...
1
vote
1answer
4k views

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

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.
1
vote
4answers
62k views

Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking. My data might look like this: London 23 London 22 London 44 London 18 ...