Graphs, charts and other graphical methods for showing data and their relationships.

**-1**

votes

**1**answer

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

**1**answer

1k views

### Excel coloured line chart for grouped data?

In Excel how do I create a line Chart with each simulator being its own coloured line showing Calculation time (and potentially another colour for its Total time).
Axis X = Rounds
Axix Y = Time ...

**2**

votes

**0**answers

147 views

### Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...

**4**

votes

**1**answer

48k views

### How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...

**2**

votes

**2**answers

293 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

**2**answers

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

**-2**

votes

**0**answers

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

**1**

vote

**0**answers

254 views

### LO Calc: Why are data labels placement options greyed out?

When creating pie charts I like to add the values of the individual slices to the chart. LO Calc allows you to do this ('Add data labels') By default Calc places these values in the center of the ...

**2**

votes

**1**answer

13k views

### A sensible way combine two stacked bar charts in Excel?

I have one chart that has several stacked bars with identical components - one for each category.
Each of the components of those bars can also be represented with a stacked bar chart, like the ...

**1**

vote

**3**answers

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

**2**

votes

**2**answers

7k views

### Excel Scatter Chart with category based formatting of points

I have some data which I would like to plot in the scatter chart in the following format
date, category, value
01-Jan,Cat1,0.03
01-Jan,Cat2,0.13
01-Jan,Cat3,0.27
01-Jan,Cat4,0.32
...

**0**

votes

**0**answers

394 views

### Excel VBA updating graph data

I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...

**4**

votes

**2**answers

8k views

### How to make a chart that graphs frequency of entries?

I have an Excel workbook that has nothing but dates (sorted), in the following manner:
11/14/2011 11:53
10/14/2012 11:53
11/23/2012 19:28
12/24/2012 12:27
...
12/1/2013 11:48
I would like to create ...

**0**

votes

**2**answers

118 views

### Embed Excel Charts into Powerpoint Issue

I am currently experiencing an issue with powerpoint 2010. I have created a three part chart in Excel and am trying to export it to powerpoint. However whenever I try to paste special the excel as an ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

567 views

### Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.

**0**

votes

**1**answer

2k views

### How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis.
For example, I imagine the questions ...

**1**

vote

**1**answer

1k views

### Create a excel chart only with axis

I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100
Is this possible? If so how to do it?
...

**0**

votes

**1**answer

135 views

### excel chart: how to change data points format in part of the curve?

Suppose I have a curve of x(t), data points are shown as blue squres.
Is it possible to easily set it, so that when x(t) is less than 0, the point will be shown as red circle?
I know each data point ...

**1**

vote

**1**answer

554 views

### Expanding set of y axis values in chart, developed by MS-excel?

I have developed a chart from a set of values of excel file, Now what I have to do that I have to expand the y axis values from point 5 to point 8, Can anyone please suggest me that how to do that.
I ...

**0**

votes

**1**answer

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

**4**

votes

**1**answer

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

**2**

votes

**1**answer

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

4k views

### ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that?
Sub DeleteGraph()
Dim graph As ...

**0**

votes

**1**answer

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

**2**answers

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

**1**answer

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

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

**1**

vote

**2**answers

807 views

### Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

It could be an easy question but I can't find a proper way to accomplish my task.
I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph ...

**0**

votes

**0**answers

33 views

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

I'm 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 know what ...

**1**

vote

**1**answer

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

**4**

votes

**1**answer

422 views

### Line Graph using Row summations

I'm having some trouble in Excel producing a line graph for the following data:
+------+--------+-----------+-----------+
| Id | Type | Owner | Date |
...

**1**

vote

**2**answers

2k views

### Changing the axis labeling in a Excel 2010 scatter plot

I am trying to represent a list of data points in such a way that the graph starts at X coordinate '1' but that labeling starts at coordinate '100' and I have been unable to find out how to do it as ...

**0**

votes

**1**answer

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

**6**

votes

**2**answers

11k views

### How can I stop Excel from rapidly refreshing/flickering while data is being loaded from external sources?

I have an Excel spreadsheet with several charts on the same worksheet. Each chart's data comes from a different table. Each table's data is pulled from an Access database, and the connections for each ...

**-1**

votes

**0**answers

1k views

### Google Spreadsheets Error: All series on a given axis must be of the same data type [closed]

I am trying to use embed interactive column charts from Google Spreadsheets for a website. However, when I enter the HTML code into the website I get the following error:
"All series on a given axis ...

**1**

vote

**1**answer

586 views

### Highlight a column in excel chart from a dropdown

I have a sheet with site name and associated values.
Site1 100
Site2 123
Site3 432
...
Site20 234
and this is represented in a column/bar chart.
there is a dropdown list of the site names. ...

**0**

votes

**1**answer

620 views

### How can I create a compound bubble and pie chart?

I'm looking for a way to create a compound bubble and pie chart likes this one:
I know that ManyEyes could do it, but I don't want to upload my dataset to the public. How can I accomplish this?

**2**

votes

**1**answer

14k views

### Excel 2010 chart does not show x axis value

In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis ...

**-2**

votes

**1**answer

49 views

### How can I draw the data in Microsoft Excel?

I have the following date in Microsoft Excel.
What I want to do is make the threshold as the x-axis, and each value corresponding to the threshold (i.e; H1, H2, etc) be on the y-axis.
So, for ...

**4**

votes

**2**answers

504 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

737 views

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

**4**

votes

**1**answer

8k views

### Multiple bar charts on one axis in excel

So I have a bunch of series laid out like this in excel:
I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column ...

**0**

votes

**2**answers

2k views

### Excel 2007 Stacked Column Chart Display Subvalues

So I have the following set of values in my excel sheet:
The values on the first column (very low, low, medium, high) are simply socio-economic layer indicators.
As you can see, everything is ...

**4**

votes

**2**answers

11k views

### Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...

**5**

votes

**3**answers

2k views

### Any ideas for graphing data with 6 million rows?

I just tried to import it into excel, but it can only accept a little over a million rows of data. It's 3 columns of data, and all I want to do is graph column 1 against 2 and 3 for two graphs.
I am ...

**1**

vote

**1**answer

7k views

### conditional chart ranges in excel

I have a table of data in Excel 2010 that looks something like this (but with hundreds of thousands of rows over multiple days):
I am trying to create a dynamic chart where the x-axis is the ...

**2**

votes

**0**answers

95 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

82 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

**1**answer

385 views

### Visio 2010 Organization chart

I'm looking to build an org chart in Visio 2010 by using data from excel. There are many tutorials about this, so this part is pretty easy.
My question is, is there a way to create automatic ...