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

**3**

votes

**1**answer

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

**3**

votes

**1**answer

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

**3**

votes

**2**answers

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

**1**answer

9k views

### How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data.
However, some data is missing, resulting in zeroes in the calculated data which the chart uses.
When ...

**3**

votes

**2**answers

7k views

### Excel: Pie Chart of a Question with Limited Possible Responses

I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. ...

**3**

votes

**5**answers

342 views

### Any good 'how to…' resources out there? [closed]

Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts?
I've reached the point where I need to do more than tables. ...

**3**

votes

**2**answers

108 views

### Plot the area between two curves

I have a function with a parameter z similar to the above one:
y = sin(x+z)
How can I plot the values of y as a function of x and all the possible values of z in the [0.1, +0.1]?
I want to graphic ...

**3**

votes

**1**answer

41 views

### Can I convert a list of names directly into a pie chart in Excel?

I've asked a group of 50 students who their favourite teacher was. The survey has exported the data and I've sorted it, so the list is now something like:
Abrams
Abrams
Butler
Cromwell
Cromwell
...

**3**

votes

**1**answer

481 views

### How to antialias trendline in Excel?

I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly:
I have tried "...

**3**

votes

**3**answers

30k views

### How to rotate text in axis category labels of Pivot Chart in Excel 2007?

I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry).
As an example: In the ...

**3**

votes

**1**answer

372 views

### Use of Excel 2011 to produce a line graph showing amplitude variations with distance

I have 2 columns of numbers:
Column A I want to be the X axis of a smooth line graph which goes through all of the data points which shows distance.
Column B I want to be the Y axis showing ...

**3**

votes

**3**answers

478 views

### How make this graph in Excel?

I'm trying to do this kind of graph in Excel, but nothing so far.
I don't find anything like it, but it has to be this way, not bars.
starter 22,58 20,76 7,1 37,93 68,42
...

**3**

votes

**1**answer

338 views

### Best way to visualize graph on a text console?

I looking for a solution to visualize a graph on a standard unix text console. Speaking more precisely I need to visualize a graph of dependencies between files from specified set, those dependencies ...

**3**

votes

**3**answers

1k views

### How to visualize/graph a massive dataset?

I have a CSV file of data collected using Performance Monitor. It collected CPU usage at 5 second intervals for two weeks.
I need to be able to graph or visual the data in a way that'll help me ...

**3**

votes

**3**answers

5k views

### Excel Graph: how can I show two values in the same bar? Not using stacked?

I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...

**3**

votes

**1**answer

797 views

### Excel 2007 Chart - Super Simple Chart what am I doing wrong?

I have two columns.
The first column begins with "Year" followed by well years (1999, 2000, 2001, etc.).
The second column has a title of "Revenue" and is contains revenue values ($12.1M, $13.2M, $...

**3**

votes

**3**answers

52k views

### How to rename the values on Y Axis in Excel?

I'm trying to rename the values that are on my Y Axis on a chart in excel. Currently I have mapped various letters to number equivilants just to get it plotted, but would like now to have the letter ...

**3**

votes

**1**answer

43 views

### Plot an Excel Chart where the date is on the x-axis and the different times as the Two Series

I have data like this in a table:
Date Time Min RTT
3/28/16 10:00 AM 42.91
3/28/16 10:00 PM 41.81
3/29/16 10:00 AM 70.61
3/29/16 10:00 PM 42.81
I would like to plot it where ...

**3**

votes

**2**answers

123 views

### How to do up a excel hair chart?

I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture.
Data:
X-axis: dates (weekly data)
Y-axis: interest rates
Doing this, I can ...

**3**

votes

**1**answer

43k views

### Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data:
Date (from 1st till 31st)
Variable 1
variable 2
I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis,
I plot the date on the graph so:...

**3**

votes

**1**answer

5k views

### Add custom forecasting line in Excel Charts

I got the following graph (in purple):
I want to add the dotted forecasting line.
It's a cell value, but not referenced to the point on the X-Axis (Oktober 13).
I'm a bit lost as to how I could ...

**3**

votes

**1**answer

1k views

### Print an organizational chart to PDF from JSON data?

I've been searching for a few days and haven't found quite what I need yet.
I've got a tool I'm working on that displays a person in a sort of visual hierarchy of the company (from the CEO down the ...

**3**

votes

**2**answers

471 views

### Simplest Automated Analysis and Chart Generation Tool?

Are there any products that can take a CSV of info, and quickly generate commonly-asked for info? I'm wondering if there's any way easier than pulling this into Excel or Matlab and manually doing all ...

**3**

votes

**1**answer

177 views

### Excel 2010 create pie chart with labels which apply to more than one segment

I want to create a pie chart with data labels which refer to more than one segment.
I have found an approximate way of doing this - these are the steps I followed.
My data looks like this:
I want ...

**3**

votes

**1**answer

899 views

### Free or Open Solution for Storing and Charting CSV data [closed]

I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet.
I've looked at OOBase, but appending csv files to ...

**3**

votes

**1**answer

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

**2**

votes

**4**answers

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

**2**

votes

**3**answers

19k views

### How to highlight data points in a scatter chart in excel?

I have a scatter chart with a series of numbers in Excel. Most of the time, those numbers are high (>1000). I would like to display the scatter chart with those numbers in the default color, but if ...

**2**

votes

**3**answers

273 views

### What tool to use to create a chart like this one? [closed]

Which tool can you recommend to draw such a diagram:
I have tried Excel, but it is not really straight forward.

**2**

votes

**4**answers

9k views

### How to make bar graph shorter for higher numbers?

I would like to inverse the bar graph in a way that the lower the number, the higher the bargraph should be.
Currently in the picture below, those items ranked 200 have the highest bar height while #...

**2**

votes

**3**answers

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

**2**

votes

**3**answers

18k views

### Creating a chart using a dynamic named range in Excel 2010

I am trying to create a scatter plot in Excel 2010 using dynamic named ranges and am having trouble getting it to work. Here's simple example that is failing:
Open Excel, starting a new workbook
...

**2**

votes

**1**answer

21k views

### How to display series name inside bars of stacked bar chart?

I have a very busy stacked bar chart, some 20 or so series over time
I am not interested in the actual numbers, I just want to show the overall trend over time.
The default colours in Excel 2010 are ...

**2**

votes

**2**answers

39k views

### Finding X on Excel scatter plot/trend line

If I have some data in an scatter plot in Excel, e.g.
X Y
1 10
2 20
3 30
4 40
5 50
and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've ...

**2**

votes

**1**answer

13k views

### Create two axis stacked columns chart in Excel

The data I'd like to chart is like this:
2000 2001 2002
A x x x
B x x x
C x x x
D x ...

**2**

votes

**1**answer

4k views

### How to make a concentric pie chart in Excel?

I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it.
I have seen those ...

**2**

votes

**1**answer

116 views

### Can I use 2 different Columns of Data for the same axis & same series in Excel

I have a simple dataset in Excel showing Players, Win Count & Win %
I'd like on my Bar Chart to keep the % on the Vertical Axis like it currently...
But I'd also like to put the Win Count on ...

**2**

votes

**2**answers

285 views

### Advanced graph in Excel

This is my data:
Date Electricity Electricity2 Electricity3 Water Oil level (cm)
2011-06-30 8508 16041 7521 794 /
2011-07-10 8568 16170 7601 800 ...

**2**

votes

**2**answers

274 views

### Graph-like data editor tool?

Is there any unified editor program for creating, mainpulating and visualizing graphs, trees... or maybe any custom structured data. The accent is on editing, not visualization, i.e. not a drawing ...

**2**

votes

**1**answer

885 views

### Animate Excel Chart

I'm preparing for an Ignite talk and need to figure out how to animate an Excel chart, which will eventually go inside a PowerPoint. I would like to animate the following into a single chart/slide.
...

**2**

votes

**3**answers

5k views

### Logarithmic X-axis in Excel puts axis numbers in wrong position

I have a dataset with logarithmic x-values (of concentration being diluted by a factor of 10) and regular (non-logarithmic) y-values. When I format the x-axis to use a logarithmic scale, the y-axis is ...

**2**

votes

**1**answer

28 views

### Line chart in LibreOffice - data in rows (type, x, y) rather than in a 2-input table

How do I create a line chart in LibreOffice Calc if the data is organised in 3-tuples rather than in a two-input table?
Example:
Banana Jan 10
Banana Feb 20
Banana Mar 30
Banana ...

**2**

votes

**2**answers

88 views

### How to do a conditional formatting in a table from a graph?

As you can see in this example below, I would like to be able to put in red the negative numbers that are in the table below the graph. I would like to apply a conditional formatting on this table (...

**2**

votes

**1**answer

422 views

### Excel: How to create a nonuniform stack chart

I want to create a stack chart that shows the timeline of 3 phases on the x-axis (intervals separated by month) and total budget on the y-axis. The budgets for all projects will stack up against each ...

**2**

votes

**1**answer

2k views

### Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this:
2014-02-20 23:04:57.9263690 +00:00
2014-02-20 23:05:02.3117944 +00:00
2014-02-20 23:05:02.7490564 ...

**2**

votes

**2**answers

10k 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
02-Jan,...

**2**

votes

**1**answer

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

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

**2**

votes

**1**answer

2k views

### Windows programs to create timeline charts?

I would like to create a chart for my source control depicting the trunk and all the branches, with various details, like creation date, merge date, created revision, merge revision, close revision ...

**2**

votes

**1**answer

625 views

### Scattergraph in Excel?

I am not sure if this is the right site, though here's my question:
I've been trying to make a scattergraph with Excel, but not getting the result I want. I have 2 data values for one thing. I don't ...