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)

-2
votes
0answers
11 views

I need application for create graphs like as gnuplot, but for “windows user” [closed]

I'm looking for application like gnuplot. I need to do a lot of Bitcoin graphs from .csv data files. Gnuplot for me is difficult. Can you recommend me other tool?
0
votes
1answer
27 views

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

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
0answers
36 views

Excel: How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
1
vote
1answer
34 views

Excel Scatter Diagram

I have data in Excel as follows (just example of them, not all): Name | Asset | Count ----------------------------- John | Apple | 1 Adam | Banana | 2 Pete | Apple | 1 Mark | Berry ...
2
votes
1answer
50 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 ...
0
votes
1answer
34 views

How to use Photoshop ot other software to make this kind of picture?

Here is the pic: Make one part stand out by making the other part grey. How to do that in Photoshop or other software?
2
votes
1answer
99 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 ...
0
votes
2answers
168 views

Excel 2010 line chart; limiting data points to fewer than the max

In Excel 2010, how do I limit the number of data points on a line graph to the latest (or last) 4 data? I update the spreadsheet often, but only the latest data is graphed and reported.
0
votes
1answer
31 views

Excel graph showing customer representation based on size of different businesses

I would like to represent in a graph the percentage of A, B and C customers in each business unit, taking into account the size of the BU (on the X axis). Sales % A % B % C ...
1
vote
2answers
1k views

Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text ...
0
votes
0answers
41 views

Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...
1
vote
1answer
100 views

Grouping Excel charts in a Word document

I have some Excel charts that I've pasted into Word, and I would like to group them together so they move as a unit as I'm moving text around. Currently, they look like this: (forgive the rough ...
-1
votes
1answer
172 views

Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this: It might ...
0
votes
0answers
76 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
0
votes
0answers
64 views

Why is my pivot chart not saving properly in Access 2010?

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. ...
1
vote
2answers
78 views

What software can help me to draw a graph of the Inernet connection getting connected.. disconnected … etc [closed]

One of my customers is using a certain device connected to the internet, he is not sure if the device is not functioning properly or its the internet connection thats going up and down, connected ...
-2
votes
0answers
80 views

Get series values on condiation, excel [closed]

I have following data in my XLS - 8:35:01 NZLOAD app read: 2000005 01:03.0 8:35:03 Pending app INSERT 0 00:00.8 8:35:14 T4 app INSERT 1944132 00:09.6 8:35:47 NZLOAD app read: 2000005 ...
0
votes
0answers
78 views

How can I graph the bitrate of an audio file?

I found a program called Bitrate Viewer, but it draws video bitrate only. Is there any way I can view the bitrate of an audio file as well?
0
votes
1answer
69 views

Calculating Range coverage

I'm putting together a sheet that includes two data columns, 'Min Value' and 'Max Value'. All values between Min and Max values are consider the 'Range' of each entry. The goal of the sheet is to ...
0
votes
1answer
245 views

Scatterplot with variable X on X axis and Y on Y axis

I have a dataset with variable A (Age) and B (performance). I want to create a scatterplot with variable A on the X axis and B on the Y axis, but Excel is acting all weird with it. I have approx 120 ...
2
votes
1answer
5k 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. ...
1
vote
1answer
510 views

Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...
0
votes
1answer
987 views

How to show an additional single point on a line graph in Excel?

I have a data set which shows the "efficient frontier" curve and a data point showing the decision made. I wish to have the data point be plotted in relation to the frontier but as an isolated point ...
1
vote
2answers
1k views

Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0. I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10: 30, 20, 10, 0, -10, -20, -30 I have set set ...
0
votes
1answer
801 views

Solving a linear equation with excel

Sorry if this is the wrong place to ask (Meta says it's the right place but you never know) but I'm really struggling with finding a simple answer to this. I'm using Excel 2011 for Mac, and want it ...
1
vote
3answers
3k views

Plot cumulative data in Excel

Is it possible to plot data in excel without having to define the function of the data in an extra column? Think of this simplified example: There are two columns with numbers A and B. Is it ...
0
votes
0answers
26 views

How can I create a “spectrum” graph in Excel? [duplicate]

I'm currently performing some data analysis, I would like to create a "spectrum" graph like the link below to indicate the distribution of some special data occurred over a series of events. (I don't ...
1
vote
0answers
34 views

Tool for associative graphing

I'm looking for an app or some computational way that would help me create interactive associated lists. Basically, I have three columns of data that have many to many relationships, and when one is ...
0
votes
1answer
104 views

Line Graph Adding Value of Series 1 to Series 2

I'm working on a line graph that contains two lines (each representing two different sets of data) with percentage values for each time period. In the first time period, the value for Set A is 3% ...
2
votes
2answers
243 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
222 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
47 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
61 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
449 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
512 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 ...
1
vote
3answers
627 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
248 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
31 views

Automated merging of PDF graphs [duplicate]

I was wondering if there is a way to combine PDF graphs automatically, I have similarly named files in 4 different directories. I have been reading about Ghostscript, imageMagick and PDFtk but I am ...
2
votes
1answer
282 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 ...
0
votes
1answer
261 views

Creating multiple plot per level of factor (trillis graph) in excel

Is there way to automate the process to make graphs like the following (also known as trallis graph) in excel ? I know there are some R interface with Excel (some of them need to be purchased), but I ...
1
vote
1answer
93 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
37 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: ...
2
votes
2answers
600 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
802 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 ...
3
votes
1answer
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
1answer
360 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 ...
1
vote
0answers
154 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
156 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
262 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
1k 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 ...