A graph is a diagram representing a relationship, system or connection between two or more points or sets of data.
1
vote
2answers
71 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 ...
0
votes
1answer
24 views
How do I stop Excel from showing a graph value which is different from the data?
My problem is that excel graphs are showing my data differently from the data that I'm using to plot it.
From the example below, the purple line Ebay/Play etc. is being plotted, but from point 28, ...
2
votes
0answers
31 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 ...
2
votes
1answer
41 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 ...
0
votes
2answers
34 views
Line Graph with Date on X axis and occurrence on X axis - Excel
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
...
0
votes
1answer
44 views
Excel: create a graph with “string” value and not numbers
I need to create a graph in Excel that takes the values from a table that describes the products with words like "low", "middle low", "middle high", "high"; and I need that on the graph appear those ...
0
votes
2answers
69 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? ...
0
votes
1answer
60 views
generate heatmap using list of IP addresses
I have a list of IPv4 addresses and I want to generate a heatmap of where the IP addresses are located. Is it possible to do it? IF it is possible can anyone please tell me how to do it?
Thanks.
2
votes
0answers
71 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
...
1
vote
1answer
37 views
combining two plot type in excel
I want to combine xyline plot with bar plot in excel.
I created xyline plot and then added new series with a hope that I can chance the series 1 later.
Step1: But it turned to be not true, see the ...
0
votes
0answers
28 views
Are there File Managers where I can show connections between files in the same directory?
Without creating new directories, is there a file manager that can illustrate relationships between files/folders in the same directory?
For example, I would like to turn something like this:
...
0
votes
0answers
99 views
How to graph events per time in excel (from log file)
I have a log file in the following format:
A | B | C | D
DD.MM.YYYY|HH:MM:SS|DEVICE|EVENT DESCRIPTION
what I want to do is, create a graph with the time on the x-axis and the events ...
2
votes
2answers
141 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 ...
0
votes
1answer
180 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 ...
2
votes
1answer
128 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 ...
1
vote
2answers
144 views
Tree Graph Generator
Is there any program that generates file from for example .csv file?
I have a tree structure that has 8 levels and about 3500 nodes.
Can you please help me by recommending me a tool that can help me ...
3
votes
1answer
189 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 ...
0
votes
0answers
104 views
pfSense RRD Graph Renders without Data
I just did a new install a couple days ago. Once i installed it and got the basic settings done, my RRD graphs was working. Now I dont know what i did, or what happened. My RRD graphs renders without ...
1
vote
0answers
97 views
How to make a 3d model from mathematical function graphs in each view?
I want to make a 3d model by graphing 2d mathematical functions in each view (top, left, front) to make surfaces for example in x-y view 2 curves with y1 = f(x), y2=f(x) and 2 straight lines make a ...
2
votes
1answer
69 views
Graph with uneven spacing in excel
I need to make a graph of follow-up data at 0, 6, 12, and 24 months. Excel for Mac 2008 puts the 24 months at the 18 month position. How do I get the correct spacing without including 18 months?
1
vote
2answers
131 views
Interactive Graph visualization
I have a graph file (in DOT format, as well as SVG) containing thousands of nodes and edges. All the nodes and edges have different labels etc.
It is difficult to comprehend and find the information ...
0
votes
2answers
358 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
...
1
vote
1answer
201 views
Lines over data in Excel 2007 Scatter Graph
I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second ...
1
vote
2answers
50 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?
2
votes
0answers
353 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 ...
1
vote
1answer
176 views
Excel 2007: plot data points not on an axis/ force linear x-incrementation without altering integrity of non-linear data
In Excel, how does one go about plotting points that don't have an x component that is an x-axis label?
For example, in my graph, the x-components are derived from the cosine function and aren't ...
1
vote
2answers
355 views
Excel 2010 column graph round percentage values to over than 100%
I have a graph showing percentages with a Data Table alongside. Excel 2010 rounds the values so that columns can sum to more than 100%, but I want every column in the graph to total exactly 100%.
...
1
vote
1answer
318 views
How to plot 3D graphs in Excel from CSV data?
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one ...
0
votes
0answers
71 views
Tools for drawing graph [closed]
what is the best tool to draw graph like this? If using visio, what template should I use? Thanks, I am using Windows 7.
0
votes
1answer
439 views
Ascii-art graphs in Linux
I have a text file that represents the runtime of a specific script, with each line representing one run:
141
124
156
204
498
512
444
374
189
120
143
132
One can see that the section that I pointed ...
1
vote
2answers
119 views
Generate a visual representation of a graph (graph theory)
Given the following paths on a directed graph:
(A --> B --> C)
(C --> B)
(C --> A)
I want to find a way to generate a visual representation for this directed graph. Is there any ...
0
votes
1answer
456 views
how to extract data from an image graph
I'm looking to get that from a graph. but problem is that graph is in image form. Now I want to extract data in excel from that graph. how can i do it? I'm using office 2003.
0
votes
1answer
92 views
Graphics driver is not accepted by Windows after restart
My computer is very slow. After installing the graphics driver, the computer is fast and everything works fine.
After a reboot the OS (Windows 7) does not accept (or find) the graphics driver ...
0
votes
2answers
2k views
How to create a scatter chart?
I select "Scatter" get the empty chart, RMB inside the chart, and click "Select Data". Up pops "Select Data Source", with entry elements "Chart data range", "Legend Entries (Series)", and "Horizontal ...
3
votes
1answer
104 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 ...
0
votes
1answer
177 views
All cells in column as graph source except header
I want to create a graph of all values in a column, except the first which is a header. I could do this by selecting the following as Series X Values:
=Foo!$A$2:$A$8
Problem is that I'd have to ...
0
votes
2answers
641 views
Excel Line Graph with columns and rows transposed
My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B ...
1
vote
1answer
88 views
Software to draw recursive processing graphs (like in the example)? [closed]
Which software is used to draw these (recursive processing) graphs?
Example at json.org:
Example at sqlite.org:
1
vote
2answers
1k views
Excel graph - two lines, one axis with date
I want to make Excel chart that shows my accounts' balances in time.
I have 2 bank accounts and I have all transactions saved in Excel. The data's format is:
Column A Column B Column C Column ...
1
vote
1answer
349 views
Real-time graphing application for SQL data
I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...
0
votes
1answer
113 views
Excel Different line graph loaded on each selection
I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, ...
0
votes
0answers
51 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:
...
0
votes
1answer
222 views
Excel per-point custom error bars
I am attempting to draw error bars on a multiple bar graph in Excel 2007, and I am having trouble with the custom error bar minimum value. First, I created the graph from multiple series, then I ...
1
vote
2answers
6k views
Easily Plotting Multiple Data Series in Excel
I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...
0
votes
1answer
27 views
Searching for a large graph image? [closed]
Can somebody direct me towards a large complex directed graph on the internet....actually I want to test the implementation of my bfs algorithm over it....the graph should contain cycles and multiple ...
0
votes
1answer
182 views
API/Tool for mining unstructured text?
I wish to create a concepts map from unstructured text. For example
Desired input: find "/" -name "*.txt"
Desired output: concepts-graph.dot
In other words, I want to mine my text files and create ...
2
votes
3answers
186 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.
0
votes
1answer
104 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
238 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
291 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.
