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)

0
votes
1answer
213 views

Radial Density Plots

I am interested in making plots similar to those attached. Any recommendations on what software (or python code) to use? I suppose there are two things I would like it to do (although either one alone ...
1
vote
1answer
911 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
1k views

Excel 3 dimensional stacked bar chart howto

One of our guys in the office wants to do a proper 3D stacked bar chart. In other words, he is not just interested in having a 3D rendering of the bars, but he needs full 3 dimensions for his data (x ...
1
vote
3answers
188 views

Visualizing Parallel Branch and Bound Tree Exploration

I have written a parallel program that does a depth first branch and bound exploration of a tree. I can dump the id's (id's are like this 0, 00, 01, 0000, 0001, etc.) of the nodes at frequent ...
0
votes
3answers
56 views

tools for drawing this graph

what is the best tool for drawing this kind of graph . I tried in Msword but they were not as good as this.
1
vote
2answers
1k views

Splitting data into multiple series' in Excel Graph

I have data from a csv formatted as such: StartTime EndTime Duration Type --------- ------- -------- ---- 43:04.7 43:06.9 2200 long 43:06.9 43:08.7 1825 middle 43:08.7 ...
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
103 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 ...
2
votes
1answer
313 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 ...
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
180 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 ...
14
votes
6answers
30k 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
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) ...
3
votes
3answers
858 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
154 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 ...
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
19k 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
2answers
85 views

Is there a tool that can let me visualise timestamps by day/week/month?

On our website we record thousands of events in tables each with a unique timestamp. Is there a tool that can plot for me the number of timestamps that fall within a day, week, or month, on a graph ...
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 ...
1
vote
3answers
2k views

Software for drawing decision tree [closed]

Can anyone recommend a software package for drawing a decision tree? I have MS Office, MS Visio and Enterprise Architect if any of those can be used.
4
votes
3answers
18k 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
1k 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
650 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
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 ...
1
vote
2answers
364 views

Grapher: Edit Equations Without GUI

I'm trying to edit the equation of a Grapher file without opening the Grapher UI. I've gotten as far as knowing that I need a hex editor to do this. I can't, however, find my equation in that file to ...
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
4answers
12k 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
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 ...
0
votes
1answer
338 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
11k 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
755 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 ...
2
votes
2answers
184 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: ...
1
vote
2answers
325 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
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 ...
1
vote
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 ...
1
vote
1answer
353 views

Tools to plot time-series data

I have a time-series dataset that looks like this (a few thousands of entries spanning for a couple of years): timestamp <TAB> items_added <TAB> items_removed For example: 1286016527 ...
2
votes
2answers
774 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 ...
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
1answer
556 views

Graphing Time in the Y-Axis creates duplicate entries?

I'm trying to create a graph based on Times and Dates and the Times on the Y-AXIS are being created with duplicate values. I attached a screenshot with the problem, the 0:00 can be seen twice. Does ...
2
votes
2answers
921 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. ...
1
vote
1answer
622 views

Excel graphs: my MIN/MAX axis scaling isn't working correctly?

I have lots of graphs which I need to compare against each other. Therefore, I need a common scaling along the vertical (Y) axis. I'm encountering problems when pasting in my MIN/MAX series, and then ...
2
votes
1answer
1k 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 ...
3
votes
4answers
5k 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 ...
1
vote
0answers
364 views

How to plot this in iwork-numbers

I got an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I got another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from 0,51 ...
2
votes
1answer
520 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 ...
1
vote
1answer
412 views

Excel Graph: How can I turn data below in to a 'time based' graph

In my spreadsheet I am collecting time periods when certain values have been changed. The user is restricted to 4 time periods. I would like to show the data based on thos time periods. I've included ...
0
votes
1answer
570 views

Graph plotting software that includes the min() and max() functions

I am looking for online or offline software that can plot functions that include min() and max(). Neither of my favourites, Wolfram Alpha and fooplot seem to have these functions built in :-(
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 ...
0
votes
1answer
408 views

Grapher - For windows [duplicate]

Possible Duplicate: Anyone know of a good graph plotting app We've got Grapher which is only for mac. Do we have something similar for Windows?