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

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

50 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

383 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

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

499 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

**0**answers

560 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

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

477 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

703 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

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

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

94 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

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

**2**

votes

**0**answers

266 views

### MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation

I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...

**1**

vote

**2**answers

4k views

### Line Graph with Date on X axis and occurrence on X axis

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

1k views

### Optimally positioning pie chart data labels in Excel with VBA

I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size.
I want to display the data labels ...

**0**

votes

**1**answer

401 views

### What is the best flow diagram if you have multiple processes and projects tied together like so

I have used flow charts in school and in an attempt to create a less generic chart, I figured I will share the processes and data I wish to organize.. see what ideas are available for this complex ...

**0**

votes

**1**answer

2k views

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

**1**answer

94 views

### Custom Chart Axis

I have an Excel chart whose X-axis values are 5000, 10000, 15000 and so-on but I want them to be like 1,2,3,... i.e. divide them by 5000.
Is there any way I can accomplish this?

**2**

votes

**1**answer

860 views

### Can I provide RGB hex strings in an Excel worksheet for pie chart colors without using code?

Like user1813558 in his question "Change the pie chart colors" I would like to choose the colors that Excel uses for a pie chart (indeed for any chart) as I need them to be consistent with other data ...

**3**

votes

**1**answer

821 views

### 1/3 octave band chart in Excel?

I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this ...

**0**

votes

**1**answer

163 views

### Column graph with multiple grouped values and one value above all of them as goal and with filled space between

I wish to create some kind of a special chart. I have 4 values, 3 are values measured over 3 years for state and the 4th is the goal where should it all go in future. The chart I want is a column ...

**0**

votes

**0**answers

399 views

### Excel Radar chart to visualize data

I have a set of data with which I want to produce a Radar chart for easy comparison.
This is just like an inventory list with A,B and C as the products list, I want to achieve the following :
...

**2**

votes

**1**answer

753 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

**2**answers

192 views

### Excel for Mac - chart with no interpolation of discontinuities?

I would like to draw a chart in Excel for Mac with no interpolation on discontinuities, like this:
How can I do that?

**1**

vote

**1**answer

2k views

### pivotslicer connected to multiple pivotcharts

Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes:
Department
--> Section
If I choose "Section A" Then I can ...

**0**

votes

**1**answer

534 views

### Excel PivotChart count rows where not blank

I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was ...

**0**

votes

**1**answer

198 views

### Excel 2010 charts from ungrouped data

I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such
Falun
Borlänge
Stockholm
Uppsala
Borlänge
Stockholm
...

**1**

vote

**1**answer

3k views

### How can I increase Excel's graph axis area?

This is what the x-axis of my graph currently looks like (Excel 2010):
The dates are in the format YYYY-MM-DD, but as you can see month and date are chopped off. I tried resizing (the dots at the ...

**0**

votes

**1**answer

835 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

**1**answer

31 views

### How to efficiently analyze simulation results with various degrees of freedoms?

I have been doing a lot of application testing, trying different libraries, threading ratios, operation distributions, etc... I want to be able to quickly generate graphs from my run data.
The data ...

**0**

votes

**1**answer

431 views

### Getting more than 100 data points to only represent part of 100%

I am trying to graph stance phase of gait, which in only about 60% of the entire gait cycle (heel strike of one foot to heel strike of the same foot) But in the data out put there are 140 cells or ...

**2**

votes

**3**answers

58k views

### XYZ 3D-chart in Excel

I have a table of data as follows:
X Y Z
N1 2 5 6
N2 2 7 8
N3 0 1 2
N4 0 4 5
N5 9 10 10
N6 4 9 9
N7 0 2 4
N8 0 7 8
N9 0 7 8
Now I would like to ...

**1**

vote

**1**answer

159 views

### Combining two plot types 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.
Step 1: But it turned to be not true, see the ...

**1**

vote

**1**answer

6k views

### Adding 80% horizontal goal line to pivot chart

I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line.
I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...

**0**

votes

**2**answers

14k views

### Is it possible to create a broken X axis in Excel 2007?

I'm trying to find a solution to a problem that I have with my data.
In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the ...

**0**

votes

**1**answer

80 views

### Excel table / chart issue when updating the select data to a smaller amount

I believe I have a simple fix but cannot find the answer anywhere online.
I have a table that looks something like:
date / total1 / total2 / total3
mon / xxx / xxxx / xxxxx
tue / xxx / ...

**4**

votes

**1**answer

2k views

### Sample data to create Excel timeline

I am trying to create an Excel timeline like the one shown here. I am not understanding how the sample data would look and how to go about making this. Please post a screenshot or explain how to ...

**2**

votes

**2**answers

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

**1**answer

325 views

### Scatter diagrams with group labels for X/Y coordinates

I'M trying to create a map layout from an Excel spreadsheet in Excel 2003.
I have x and y coordinates in columns as well as group name and place name. I tried using a scatter chart but I can only ...

**1**

vote

**4**answers

37k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**0**

votes

**1**answer

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