**0**

votes

**1**answer

9k views

### Prevent Excel from resizing graphs

When a row or column is inserted around a graph in Excel, Excel automatically resizes (expands) the graph. This corrupts the dimensions I determine for a specific graph. How can I prevent Excel from ...

**3**

votes

**2**answers

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

**0**

votes

**0**answers

10 views

### Audio to graph software

I'm looking for a software that shows the opened/imported audio in a graph. I know there are some free audio editors like Audacity, but I'm looking for something that gives me control over the graph. ...

**-1**

votes

**1**answer

23 views

### Is there a software for easily creating and visualising a graph/map of linked nodes with text? [closed]

I've been handling some lists in plain text going like this:
->go to shop-> shop for groceries -> make meal -> eat meal -> profit ->
->go to shop-> shop for spare lightbulb -> ...

**3**

votes

**1**answer

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

**3**

votes

**1**answer

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

**1**

vote

**1**answer

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

**4**

votes

**3**answers

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

**5**answers

626 views

### Software for “relationship graphs” [closed]

I don't think I'm using the right terminology here, but I'm looking for some software that will generate an optimal "relationship graph" given the relationships.
For example if you have an entity A ...

**-1**

votes

**0**answers

4 views

### calculate AUC (GAM) in R [migrated]

I used the following script to calculate AUC in R:
library(mgcv)
library(ROCR)
library(AUC)
data1=read.table("d:\\2005.txt", header=T)
GAM<-gam(tuna ~ s(chla)+s(sst)+s(ssha),family=binomial, ...

**0**

votes

**2**answers

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

**1**

vote

**2**answers

260 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

**2**answers

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

**2**

votes

**4**answers

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

**1**

vote

**1**answer

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

**15**

votes

**7**answers

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

**1**

vote

**3**answers

89 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

125 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

34 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

**1**answer

81 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

**3**answers

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

**4**

votes

**3**answers

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

**7**answers

13k views

### Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following:
The x-axis has the wrong scale - it should range from about $3000 to ...

**3**

votes

**4**answers

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

**0**answers

43 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

**1**answer

61 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

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

**1**

vote

**1**answer

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

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

**1**

vote

**4**answers

7k views

### Is there a graph paper like drawing software?

I have a college assignment, where I have to draw diagrams of voronoi, delaunay, minimum spanning tree etc for the college. I want to do that in computer. I searched in google with no luck. Is there ...

**3**

votes

**5**answers

48k views

### Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this:
2007 2006 2005
Amount 300 200 100
I want to create a graph of the time series that looks ...

**0**

votes

**2**answers

317 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

158 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

**1**answer

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

**4**

votes

**3**answers

63k views

### how to add an average line to the graph in excel 2007 or 2010

In OpenOffice I'm getting trend-line and average-line properties by RightClick. But in Excel 2007 I see only trend-line. Same with Excel 2010. How do you make an average-line in Excel?

**0**

votes

**1**answer

38 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

52 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

190 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

394 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

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

**1**

vote

**2**answers

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

**3**

votes

**1**answer

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

**0**

votes

**1**answer

76 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

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

**0**

votes

**1**answer

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

**2**

votes

**0**answers

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