A graph is a diagram representing a relationship, system or connection between two or more points or sets of data.

learn more… | top users | synonyms (1)

17
votes
7answers
34k 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 ...
8
votes
7answers
4k views

How to easily plot graph, using (preferably) free software?

I need to plot a graph, given some data, where on X axis will be names of data and on Y axis those data, and it will be given by a table, and it will be line graph with the data connected. If there ...
7
votes
1answer
26k 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 ...
7
votes
1answer
1k views

OpenOffice.org calc: how to dynamically update a data range for a graph?

I have an OpenOffice.org spreadsheet that contains a number of graphs. As I append more data to this spreadsheet, I want to update all the data ranges in those graphs, basically changing A1:A100 to ...
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 ...
5
votes
3answers
65k 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?
4
votes
3answers
23k 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 ...
4
votes
4answers
518 views

Anyone know of a good graph plotting app

Does anyone know of a free graph plotting app for windows (or online) that can plot something like this? Xn+1= r sin (π * Xn)
4
votes
1answer
2k views

Program for creating language syntax/grammar “railroad” diagrams?

I'm looking for the program that JSON, SQLite and other projects are using to create the diagrams used for their language syntax, if there is a particular program. All of the diagrams have a similar ...
4
votes
3answers
2k views

Creating map of countries colored using country statistics

I want to create a PNG (or GIF) image, with geopolitical map of countries, where each country has color set according to some country statistics (e.g. 'USA' has n, 'Canada' has m, etc.). Something ...
3
votes
1answer
14k 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 ...
3
votes
5answers
50k views

Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this: 2007 2006 2005 Amount 300 200 100 I want to create a graph of the time series that looks ...
3
votes
3answers
3k views

Graphical GUI for Graphviz on Mac?

I installed the Graphviz GUI from pixelglow.com, but it appears to only be a viewer for .dot Graphviz files. I am looking for a graphical editor, where I can create diagrams by pointing and ...
3
votes
3answers
691 views

Fourier transform software [closed]

After spending a lot of time searching for this, I thought that some Super User gurus might know the answer. I'm searching for an open source application to compute a FFT, that could: Import a ...
3
votes
5answers
6k views

Excel graphs: how can I extract a graph legend and place it on the worksheet itself?

I have 8 graphs all with the same legend (line colours and meaning), so in order to save space I would like to remove the legend from each graph and create/include just one large one at the top of the ...
3
votes
1answer
6k views

How to plot survey results on Excel?

I would like to plot the average of these data sample: 1. Contribution to the project 2. Affiliation with project owners 3. Level of expertise 4. Learning Curve Yes No 3 2 No No 3 2 No No ...
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 ...
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. ...
3
votes
1answer
8k 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. ...
3
votes
3answers
295 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 ...
3
votes
1answer
211 views

What's the best way to visualize graph on a text console?

I looking for a solution to visualize a graph on a standard unix text console. Speaking more precisely I need to visualize a graph of dependencies between files from specified set, those dependencies ...
3
votes
3answers
968 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 ...
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 ...
3
votes
1answer
212 views

Use of Excel 2011 to produce a line graph showing amplitude variations with distance

I have 2 columns of numbers: Column A I want to be the X axis of a smooth line graph which goes through all of the data points which shows distance and Column B I want to be the Y axis showing ...
3
votes
1answer
660 views

MS Word figures with same font size (style) as document

When writing (e.g. techical reports) in Microsoft Word (or another text processor), I often produce figures as image files using a range of different programs. These programs can be matplotlib ...
3
votes
1answer
420 views

What do “BGP graphs” show (e.g. Hurricane Electric (HE))?

Title says it: I am wondering what "BGP graphs" (e.g. the ones on Hurricane Electric or robtex) show exactly? Another example can be found here on superuser: Is there a way to test alternate IPv4 ...
3
votes
1answer
2k 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
196 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 ...
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 ...
2
votes
3answers
239 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.
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 ...
2
votes
7answers
33k views

Map one column to x axis second to y axis in excel chart

I'm getting my ass kicked trying to plot simple data into a simple chart in excel (2010 beta). My data is a very simple one: Value Year ----- ---- 1 1900 5 1902 3 1912 ...
2
votes
2answers
3k views

Tool for dependency graphs

I am looking for a tool that will let me work on a dependency graph. (I want this for my personal tasks, like a to do list.) Like, let's say I have task 1, 2 and 3. Then maybe task 1 is needed for ...
2
votes
1answer
8k views

How do I divide one column in gnuplot?

I have gnuplot data file. I would like to plot it, but divide every value in the x-axis by n. Can I do this from within gnuplot, or do I have to rewrite the data file?
2
votes
1answer
369 views

Looking for a graph program for time series

I want to find software (Windows or Linux) that can create time based graphs with the following wishes. Can you suggest which programs come closest to my wishes? Whishlist: The x-axis has to ...
2
votes
1answer
987 views

How to draw a 'sane' scatter plot in Excel?

I've been at it for over 2 hours now and am just a bit flustered :) I have the following data (for example): Label | Criterion 1 | Criterion 2 | A1 | 7 | 3 | A2 | 1 ...
2
votes
2answers
228 views

Graph-like data editor tool?

Is there any unified editor program for creating, mainpulating and visualizing graphs, trees... or maybe any custom structured data. The accent is on editing, not visualization, i.e. not a drawing ...
2
votes
1answer
69 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 ...
2
votes
4answers
1k views

Can you use Photoshop to produce vector based graphics?

I am researching vector based graphics and I know people use Illustrator for these, but if you are drawing in Photoshop, does it also produce vector based graphics? Would you still save it as a .psd? ...
2
votes
2answers
836 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 ...
2
votes
2answers
452 views

Looking for PHP memory/CPU graph generator

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?
2
votes
1answer
417 views

Scattergraph in Excel?

I am not sure if this is the right site, though here's my question: I've been trying to make a scattergraph with Excel, but not getting the result I want. I have 2 data values for one thing. I don't ...
2
votes
2answers
283 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
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 ...
2
votes
2answers
1k views

Excel: ROUND() to the next unit of 5?

I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5. ...
2
votes
1answer
2k views

Excel graphs: I have created a template graph format but how do I apply it?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...
2
votes
1answer
588 views

Plotting the volume of an audio file

Most applications that play sound display its volume graphically. I need that information (the sound volume as it changes over time) written to a text file so I can plot it myself and use it for ...
2
votes
1answer
45 views

How to create a stacked bar chart that displays data in monthly intervals?

I have a table with dates and prices, and I want to create a bar chart, which shows me total amount spent in months. Table looks like this: 30.5.2014 700,80 CZK 6.6.2014 1 000,30 CZK 20.6.2014 ...
2
votes
1answer
142 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
1answer
254 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 ...