The graphs tag has no wiki summary.
0
votes
1answer
32 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:
...
2
votes
2answers
40 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?
1
vote
0answers
67 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
0answers
29 views
Display and analyze the graph of a website to check its connectivity and compute properties
I would like to check several properties of the graph behind a website I own. The properties I'm interested in are: diameter, shortest path from index page, min/max/average degree of vertices, and ...
0
votes
1answer
33 views
gnu `uniq -c`: display counts graphically as bars
With sort $file | uniq -c, it's possible to sum up files/input and show the number occurences like that:
13 foo
1 bar
To get a better grasp of this data, I'd like to see them graphically ...
3
votes
1answer
114 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 ...
0
votes
4answers
223 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
132 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 ...
0
votes
1answer
88 views
Linux Process Lifecycle Timeline Graphing/Visualization
Is there a tool that will monitor the creation and destruction of Linux processes and generate data that would enable me to graph these events with respect to time? Or, alternatively, the tool would ...
1
vote
1answer
231 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 ...
1
vote
0answers
63 views
Keep values for grouped or hidden cells in graph? [closed]
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
186 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
1answer
119 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 ...
0
votes
1answer
91 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
131 views
Excel 2010: Bar chart with values over maximum
How can I make a chart like this in Excel (2010)?
http://www.epa.gov/recovery/images/bar-chart.gif
I have data where 2 out of 20 values are disproportionately large. In order to create a useful ...
0
votes
0answers
93 views
Excel x-axis scale
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 something like this:
X Y
1 .5
2 .4
3 ...
1
vote
0answers
22 views
Tool for visualizing relevance of books on amazon
I am trying to find some useful visualization tool which would help me to browse books on amazon. I want to visualize a relevance of a book in the context of other books. So I could see what is the ...
1
vote
1answer
221 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
171 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 ...
1
vote
2answers
130 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 ...
1
vote
1answer
180 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: ...
1
vote
1answer
310 views
How do I create a line graph which ignores zero values?
I want to create a graph showing trends over time, calculated from a formula of various data.
However, some data is missing, resulting in zeroes in the calculated data which the chart uses.
When ...
2
votes
1answer
985 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 ...
2
votes
1answer
77 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 ...
1
vote
1answer
429 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 ...
0
votes
1answer
47 views
Is there any free software to easily draw time-based graph?
or Excel template to draw something like below?
0
votes
0answers
18 views
charting tool for timeseries with event labels
I need to draw a chart of some timeseries data (i.e. my weight measured each day) overlayed with some continuous events (like week when i was taking some meds or 10 days i took vacation)
So in ...
1
vote
1answer
207 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
201 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
2answers
60 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
0answers
26 views
Groups with seperation in Excel bar charts
Wondering if anyone knows how to do this.
I have 5 metrics and targets for each metric. So AB, CD, Ef, GH, IJ.
I also have these numbers spanned over 7 days for the week.
Firthermore I have one ...
0
votes
3answers
43 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
154 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
52 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
61 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
89 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
68 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
...
4
votes
3answers
694 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
188 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
304 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
81 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
...
6
votes
1answer
336 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 ...
4
votes
2answers
1k 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
0answers
39 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 ...
1
vote
1answer
293 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
271 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
505 views
Software for drawing decision tree
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.
1
vote
3answers
880 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
464 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
298 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 ...
