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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

329 views

### How to define an organizational hierarchy in Visio 2010?

How do you create the relationships between positions in a Visio 2010 Organizational Chart?
I have created the chart, added several positions to the chart, and now I wish to define which positions ...

**9**

votes

**1**answer

36k views

### Create a pie chart from distinct values in one column by grouping data in Excel

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).
How can I make Excel group all the distinct values together and then display ...

**3**

votes

**1**answer

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

**1**

vote

**1**answer

5k views

### Excel: Charting date, time elapsed, and another value

I'm trying to chart growth in our nightly backups. The three values I'm using are the date of the backup, the backup job size in bytes, and the time the job took to completely in hh:mm:ss.
Using ...

**0**

votes

**1**answer

769 views

### Good chart drawing software? [duplicate]

Possible Duplicate:
Application to help build diagrams
I'm looking for a program, which I can use to draw good and smooth-looking charts. I would prefer it to be free, but it is another ...

**0**

votes

**1**answer

114 views

### Is there any free software to easily draw time-based graph?

or Excel template to draw something like below?

**1**

vote

**1**answer

63 views

### Downloadable map data usable in applications [closed]

I wish to create a small pathfinder application with maps.
Where can I download navigation European map data and find documentation about their formats?

**2**

votes

**4**answers

12k views

### How can I create proportionally-sized pie charts side-by-side in Excel 2007?

I have a pivot table with two sets of data as follows:
2011 2012
Slice A 45 20
Slice B 33 28
Slice C 22 2
I am trying to present two pie charts ...

**2**

votes

**1**answer

377 views

### Excel distorting markers in scatter plot

I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For ...

**0**

votes

**1**answer

953 views

### How can I make a bar chart in OpenOffice Calc where the bars have two different colors to signify two different types of products?

I'm sure most people have seen the Intel vs. AMD charts that places like TomsHardware.com use, but just in case you haven't, here is my chart:
I want the PV bars in black, and the Solar Hot Water ...

**0**

votes

**1**answer

310 views

### Radial Density Plots

I am interested in making plots similar to those attached. Any recommendations on what software (or python code) to use? I suppose there are two things I would like it to do (although either one alone ...

**1**

vote

**1**answer

1k views

### Plot disproportionate values in single graph with Excel

I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One ...

**0**

votes

**1**answer

2k views

### Excel 3 dimensional stacked bar chart howto

One of our guys in the office wants to do a proper 3D stacked bar chart. In other words, he is not just interested in having a 3D rendering of the bars, but he needs full 3 dimensions for his data (x ...

**1**

vote

**4**answers

4k views

### Best tool for creating organizational charts? [duplicate]

Possible Duplicate:
Application to help build diagrams
I need to find a Windows tool/software, or an online service, for creating organizational chart for the company I'm employed at.
I ...

**0**

votes

**0**answers

38 views

### Chart from groupings

Given such a spreadsheet:
col1 | col2 | col3
-----+------+----
alfa | foo | 10
beta | foo | 20
gamma| bar | 12
delta| bar | 42
I'd like to generate a chart grouping values from col2 and ...

**3**

votes

**2**answers

642 views

### Chart data by month

I've the following data in an excel spreadsheet:
Date (dd/mm/yyyy) Value
----------------- ---------
01/04/2011 123.45
03/04/2011 7234.25
16/05/2011 80.00
...

**1**

vote

**0**answers

68 views

### Finding more flexible 'chart-to-code' software

I'm looking for suggestions of a new software development tool for any object-oriented development language
e.g. C++ , C# , VB etc.
Here's some examples of some software coding:
I'm looking for ...

**6**

votes

**2**answers

28k views

### Excel: How to display superscript text as data series on chart?

I have a line chart in Excel 2007 that is created from data in the worksheet. It has several series whose titles are displayed in the chart on the right side. The names of the series are of the form ...

**1**

vote

**2**answers

329 views

### Desktop software for data analysis, like Business Objects “Lite”

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and ...

**0**

votes

**3**answers

60 views

### Tools for drawing this graph

what is the best tool for drawing this kind of graph? I tried in MS Word but they were not as good as this.

**9**

votes

**2**answers

20k views

### Excel pie chart: How to combine smaller values in a single “Other” slice?

I have this pie chart in Excel 2010 (based on a pivot table):
I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the ...

**1**

vote

**2**answers

2k views

### Splitting data into multiple series' in Excel Graph

I have data from a csv formatted as such:
StartTime EndTime Duration Type
--------- ------- -------- ----
43:04.7 43:06.9 2200 long
43:06.9 43:08.7 1825 middle
43:08.7 ...

**0**

votes

**2**answers

3k views

### Make the first row of an Excel chart be treated as a heading when it's a number?

Given a data sample like
Prisoner 24601 0.50
Day 1 80 90
Day 2 81 89
Day 3 82 90
Day 4 81 91
What's the easiest way to tell Excel that 24601 and 0.50 are data series names rather ...

**2**

votes

**2**answers

6k views

### Excel: Bubble chart labels - use 4th dimension?

I've got a dataset that has 4 dimensions - lets say they're the following:
+------------------------------+
| Type | Amnt |Price| Quality |
+-------|------|-----|---------+
| A | 15 | 4.0 | ...

**0**

votes

**1**answer

110 views

### Creating a graph for data in Excel

I have two conditions (1-public, 2-Montessori) and a set of values based on the score of the children that is either a 0 or 1.
I need a histogram showing how many children got a 0 and how many got a ...

**2**

votes

**1**answer

431 views

### Looking for a graph program for time series

I want to find software (Windows or Linux) that can create time based graphs with the following wishes. Can you suggest which programs come closest to my wishes?
Whishlist:
The x-axis has to ...

**2**

votes

**3**answers

3k views

### Is it possible to have a custom data table visible underneath a chart in MS Excel?

I have a column chart with a single series of data to be shown on the chart.
However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...

**4**

votes

**3**answers

9k views

### Is there something like Grapher.app for Windows?

On a Mac, there is a Grapher.app which has many functions like: ordinary graphing, polar graphing, lin-log and log-log graphing, 3d graphing, derivatives, integrals, implicitly defined functions, ...

**3**

votes

**1**answer

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

**3**

votes

**1**answer

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

**21**

votes

**7**answers

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

**0**

votes

**1**answer

2k views

### excel - how to connect a graph max with original (0,0) point

If I have a spreadsheet that has the following data:
A
0 0
1 2
2 4
3 4
4 6
0-4 X Axis
A is Y Axis
First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
...

**1**

vote

**1**answer

1k views

### Math Round multiple cells, generate integers and histogram integer values

I want your help for the following points:
How generate integer values using Data menu > Data Analysis > Random Number Generation
or (if this action can't be done)
how round multiple cells in same ...

**2**

votes

**1**answer

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

**0**

votes

**1**answer

931 views

### How to generate Excel charts show per interval?

I have the following Mathematical function (I am not refer to programming language, just simply Math):
F(X)={ 1/4, X∈(0,1]
5/12, X∈(1,2]
9/12, X∈(2,3]
11/12, X∈(3,4]
}
I want to ...

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

**2**

votes

**1**answer

167 views

### Make dates appear on the X-axis and the color category appear on the Y-axis

There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...

**7**

votes

**3**answers

2k views

### OpenOffice.org calc: how to dynamically update a data range for a graph?

I have an OpenOffice.org spreadsheet that contains a number of graphs. As I append more data to this spreadsheet, I want to update all the data ranges in those graphs, basically changing A1:A100 to ...

**1**

vote

**3**answers

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

**7**

votes

**2**answers

14k views

### Excel 2007 - Custom Y-axis values

I am making a basic column chart with a few columns. The only catch is instead of showing numbers as the grid marks, I want to show words like "Very Low" and "Medium".
For example, I have
Data1 = ...

**1**

vote

**1**answer

201 views

### Building diagram in Microsoft Office Excel

Could somebody help me to build this one?
Here's image.
This diagram tells about number of CPU cores during each year (X-axis) in TOP-500 comuters (Y-axis), digits right are number of cores. It ...

**1**

vote

**1**answer

487 views

### Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?

Google Docs has a nice trend viewer that can be created just like any other chart:
Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...

**5**

votes

**2**answers

25k views

### How do I create custom axes in Excel?

I'm creating a "histogram" and need the values of "frequency" to be displayed in ascending or descending order, which means that I need custom values for the x-axis. Instead of having:
1 2 3 4 5 ...

**2**

votes

**2**answers

123 views

### Represent in a diagram how much work remains

I have a project consisting in 3 tasks.
First Task (T1) is done at 10%;
Second Task (T2) - at 50%;
Third Task (T3) - at 75%;
I need to represent it in a diagram: how many work remains to do for ...

**0**

votes

**2**answers

102 views

### Is there a tool that can let me visualise timestamps by day/week/month?

On our website we record thousands of events in tables each with a unique timestamp. Is there a tool that can plot for me the number of timestamps that fall within a day, week, or month, on a graph ...

**5**

votes

**3**answers

8k views

### Use a Trendline Formula to Get Values for Any Given X with Excel

Is there an easy way to apply the trend line formula from a chart to any given X value in Excel?
For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and ...

**3**

votes

**1**answer

1k views

### Any alternatives to Ubigraph?

Ubigraph is a different way to create interactive user interfaces with the purpose of visualizing huge amounts of data. Its visualizations are simply stunning.
The problem is that the project seems ...

**1**

vote

**2**answers

3k views

### Excel: How to create a chart that automatically scales the axis

I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.
The values are the following:
A: 412 684 944 2009 9601
B: 7813,4 10377,6 11138,8 16216 ...

**1**

vote

**1**answer

701 views

### Generate a point chart from XML data, possibly with Excel?

I would like to generate some point chart from XML data.
The data should be grouped using color by its "id" attribute. The position is stored in "x" and "y". What software should I use? I tried Excel ...