**2**

votes

**1**answer

46 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 ...

**0**

votes

**1**answer

45 views

### Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this...
The desired ...

**0**

votes

**2**answers

44 views

### Excel bar graph, easy idea, hard implementation apparently

I want to make a graph like this, but I can't seem to make it correctly:
Data: 4, 2, 3, 4, 1, 3, 3, 2, 3, 4, 2, 3, 2, 1
Three elements: Y-axis potential values (1-4 or worst, below average, above ...

**0**

votes

**1**answer

49 views

### Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks basically like this:
"timestamp","duration","ComputerName"
"7/8/2014 2:56:03 ...

**0**

votes

**1**answer

71 views

### In microsoft excel 2013, how do you find where a data point would intersect with an already plotted lineÉ

So I have a graph with one series of data, with a trend line and an associated trend line equation (y = mx + b). I have another series of data, but only of y-values. I want to find the x-values of ...

**1**

vote

**1**answer

19 views

### Using exported Google Play statistics in Excel

I have exported data from Google Play statistics, but I got this:
date,total_user_installs
20140618,291
20140617,291
20140616,291
20140615,290
20140614,289
20140613,289
20140612,288
20140611,286
...
...

**0**

votes

**2**answers

36 views

### Having some issues making specific line charts in Excel

I am sorry if this is a dumb question, but I need to pass a graph to excel and I'm failing to do so. I have no idea where to fix it.
Basically I already have one on Matlab, but I want to remake it ...

**0**

votes

**2**answers

89 views

### Excel Charts - How do i plot time on the Y axis

I am a keen runner and am trying to plot my progress on a chart using the following times
00:27:18
00:28:19
00:26:49
00:27:19
00:26:05
00:27:18
00:26:22
00:26:49
00:30:40
00:28:03
00:26:58
00:27:35
...

**1**

vote

**1**answer

198 views

### How can I set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

I was wondering if there was a way I can set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well?
Basically I have a number ...

**1**

vote

**3**answers

118 views

### How to create a Horizon Graph in Excel?

I was wondering if anyone knew how to create a Horizon Graph in Excel (preferably without needing to download an Add-In)? I believe these were originally called, "two-tone pseudo charts" developed by ...

**1**

vote

**2**answers

354 views

### How to get charts to automatically update with new data added?

If I were to have data in excel just like the table below, and then make line charts with that data. All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data. ...

**1**

vote

**2**answers

45 views

### Excel plot digitizer [closed]

Is there any plot digitizer usable in Excel? I have discrete points (values X and Y) and I have to create graph from these - Excel can create the "mean curve" (I am sorry, I am not a native speaker so ...

**0**

votes

**2**answers

93 views

### Superscripts in Excel chart labels

I have data like this:
2 | 5
4 | 6
8 | 7
I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...

**0**

votes

**1**answer

128 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

**0**answers

44 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 ...

**0**

votes

**0**answers

28 views

### Excel scatter chart to show crossbar on selected point

Is there a way to configure Excel 2010 to show a crossbar on selected point in a scatter chart? The default behavior is to show a tooltip with the point's value when hover over the mouse cursor. When ...

**1**

vote

**1**answer

71 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

**1**answer

143 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

**1**answer

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

**1**answer

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 ...

**0**

votes

**2**answers

415 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

**1**answer

39 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

**2**answers

2k 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

**0**answers

63 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

**1**answer

271 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

**1**answer

543 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 ...

**1**

vote

**0**answers

121 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

**1**answer

102 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

**2**answers

104 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

**0**answers

82 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

**2**answers

4k views

### Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking.
My data might look like this:
London 23
London 22
London 44
London 18
...

**0**

votes

**0**answers

101 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

**1**answer

84 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

**1**answer

447 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 ...

**3**

votes

**1**answer

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.
...

**1**

vote

**1**answer

869 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

**1**answer

2k 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 ...

**0**

votes

**1**answer

1k 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

**3**answers

5k 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

**0**answers

28 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

**0**answers

37 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

**1**answer

204 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

**2**answers

284 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

**1**answer

403 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

**0**answers

55 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

**1**answer

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 ...

**0**

votes

**2**answers

946 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

**1**answer

772 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 ...

**2**

votes

**4**answers

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? ...

**0**

votes

**1**answer

324 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.