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

**4**

votes

**1**answer

708 views

### Create line graph with embedded horizontal histogram

How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.

**1**

vote

**4**answers

4k views

### Good (preferably free), easy to use, attractive flowchart software [closed]

While there is no shortage of awesome concept mapping or mindmapping software, I'm left rather cold by the offerings of flowchart related software or apps available.
I'm looking for something that ...

**0**

votes

**1**answer

885 views

### Windows. Active X objects. Excel Chart

i need to find Excel active X object mschart.ocx or mschrt20.ocx.
Where are they laying?
Thanks!
P.S:
Am i right, that they can help me to use active x chart: msdn
Thanks!

**1**

vote

**1**answer

1k views

### Organization chart using Active Directory

Is there any tool which can depict Organization chart using data pulled from Active Directory.
I am looking for portable thick client which can run on Windows.

**1**

vote

**1**answer

9k views

### Excel chart axis does not depict the data correctly

I have a problem with an Excel chart.
I have
a primary axis (two series), showing volumes in millions
a secondary axis showing percentages (one series)
The primary axis seems to be adding the ...

**2**

votes

**1**answer

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

**1**

vote

**2**answers

15k views

### Symbols in Excel graphs [closed]

I am a scientist and would like to use Excel to graph data. I know many people who use Excel graphing. However, Excel graphing will not let you use symbols in the Titles, in the axes labels, or in ...

**1**

vote

**1**answer

235 views

### How to apply Excel formula to datapoints for chart *without* helper column?

in Excel (2007 or newer) is there an easy way to apply any Excel formula on a set of datapoints before drawing a line/box/... on the chart, without using a helper column to do so?
(This is a ...

**2**

votes

**1**answer

3k views

### Can I crop an excel chart to remove part of the chart?

I followed some instructions to create a speedometer chart (pie chart with a scatter line chart on top).
However, this solution leaves a large blank space below the chart; 50% of the chart's space is ...

**-1**

votes

**2**answers

6k views

### Excel scatter chart, with grouped text values on the X axis

Apples 1
Apples 5
Apples 2
Bananas 1
Bananas 4
Bananas 6
I want two bars on the X axis (Apples, Bananas), but with crosses marking the points on the Y axis.
Here's a mockup:
I'd want 1 ...

**3**

votes

**1**answer

863 views

### Free or Open Solution for Storing and Charting CSV data

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

2k views

### How to draw a 'sane' scatter plot in Excel?

I've been at it for over 2 hours now and am just a bit flustered :)
I have the following data (for example):
Label | Criterion 1 | Criterion 2 |
A1 | 7 | 3 |
A2 | 1 ...

**1**

vote

**1**answer

1k views

### Emphasize 100% axis line in Excel

I have a bar chart of %s, where some of the values are over 100%. I have the gridlines set at 20%, but would like an extra emphasis on 100% to make the better values stand up.

**0**

votes

**4**answers

4k views

### Smooth a curve by calculating / interpolating source missing values

I have a table of values like this one :
18
18
18
46
46
46
46
46
57
57
57
57
57
57
69
69
69
69
69
69
64
64
64
64
64
64
56
56
56
48
48
48
44
or if you prefer :
18
0
0
46
0
0
0
0
57
0
0
0
0
0
69
0
0
...

**1**

vote

**0**answers

467 views

### How can I change the default font size that is set on charts in a PowerPoint template?

As the title says I'm interested in knowing how I can change the default font size that is set on charts in a specific PowerPoint template.
I'm not interested in using chart-templates for this, since ...

**1**

vote

**2**answers

661 views

### Please recommend software to draw sequence diagrams [closed]

I have tried Dia, but it does not seem to provide a convenient set. Particularly, I cannot find the self-directed circle in Dia.
I drew the illustration in Word, but it is not very convenient. (The ...

**2**

votes

**2**answers

447 views

### Excel auto Gantt chart

I have a spreadsheet with 4 columns. Teachers, Class Taught, Class Start (date), Class End (date). I need to plot this in excel somehow to show what days of the month are booked by each teacher.
I1 ...

**0**

votes

**1**answer

87 views

### Comment a remarkable point in a graphic

I have a graphic like this one, based on dates/values:
Some points on the graphic represent special events, and I'd like to associate them with a comment, like: "Called the manager", "Strike", ... ...

**2**

votes

**1**answer

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

**0**

votes

**1**answer

408 views

### Linux Process Lifecycle Timeline Graphing/Visualization

Is there a tool that will monitor the creation and destruction of Linux processes and generate data that would enable me to graph these events with respect to time? Or, alternatively, the tool would ...

**0**

votes

**1**answer

6k views

### Excel chart does not show all data series

I'm trying to set up an Excel chart. I've tried to enter 6 data series. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right-hand side listing of series, it shows ...

**4**

votes

**2**answers

884 views

### How can I split the wedges of a pie chart to show extra information per wedge in consecutive rings?

I'm plotting disk partitioning and available space.
I have a pie chart showing the partitioning: e.g. 30% /, 70% /home.
In the second ring I want to show that 90% / is full, 10% of / is empty. 10% ...

**7**

votes

**1**answer

10k views

### How do I get data or percentage displayed in libreoffice pie chart?

I need to get a pie-chart with values - can libreoffice do it?

**0**

votes

**2**answers

6k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

**0**

votes

**1**answer

569 views

### Boxplots in Excel

Excel does not come with boxplot charts.
What is the best technique to simulate boxplot charts in Excel?
I'm interested to
draw horizontal and vertical charts
display the mean in addition to the ...

**1**

vote

**0**answers

69 views

### Keep values for grouped or hidden cells in graph? [duplicate]

Possible Duplicate:
Excel 2010: Can I hide columns without excluding the data from a graph?
I have a graph based on data contained in cell columns that can be grouped. Whenever I collapse ...

**0**

votes

**1**answer

37k views

### How to graph 3 different lines in the same graph with Excel?

I want to draw 3 line graphs on the same graph (to compare the data). They share the same x axis, and use the same data for the y axis but with different values. How can I do this? It's not working ...

**3**

votes

**3**answers

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

**0**

votes

**1**answer

141 views

### Excel 2007 plot with labeled data items

I have data in the following format, where each label defines a row of data:
label1 x1 y1
label1 x2 y2
label1 x3 y3
label2 x1 y1
label2 x2 y2
label2 x3 y3
This is a very large data ...

**0**

votes

**1**answer

735 views

### On a bar chart showing value gains in time frame, what is the easiest way to show losses?

I have a chart as on image below:
The red part of these charts are loses – values which should be subtracted from the overall amount. Is there any way that I can both show them on the chart and ...

**4**

votes

**2**answers

27k views

### Excel - stacked bar charts with two pairs of 'overlaps'

I'm trying to do some 'stacked' bar charts in Excel 2010 - here's a close psuedo example.
Team Buying target Buying result Selling target Selling result
Team A 80% 50% 70% 90%
...

**1**

vote

**1**answer

2k views

### Bar chart in Excel 2010 with values over maximum

How can I make a chart like this in Excel 2010?
Image from: EPA.gov
I have data where two out of 20 values are disproportionately large. In order to create a useful chart I'd like to cut out a ...

**0**

votes

**1**answer

177 views

### How to chart different shifts run times in Excel 2003

I have the following as an example.
Date Duration Shift
4-Dec 60 1
4-Dec 40 2
5-Dec 45 1
5-Dec 55 2
5-Dec 30 3
I am trying to map these ...

**1**

vote

**1**answer

2k views

### Excel x-axis scale [duplicate]

Possible Duplicate:
Excel axis problem
I jumped from an older version of Excel to the new ribbon interface and am stumped trying to make a simple graph.
I have a set of pair values that go ...

**3**

votes

**4**answers

18k views

### Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart?
I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...

**0**

votes

**1**answer

903 views

### Excel 2007 adding mean value and variance to histogram

I have to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range).
Example:
Data:
a,b,c,d,...
...

**1**

vote

**1**answer

1k views

### Record CPU usage then create Excel line chart with “Series” Column

I need to create a line chart to display the cpu usage of each process over time. How do I create the chart with time as the X axis, %CPU as the Y axis, then use the command name to indicate which ...

**2**

votes

**2**answers

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

**0**

votes

**1**answer

2k views

### How do I create this clustered column chart in Excel?

I have a data sheet split into three tables (one for each level). Within each table, there are four columns based on the answer (positive, neutral, negative, or N/A) and then there are six rows, each ...

**3**

votes

**2**answers

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

**2**

votes

**1**answer

2k views

### Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...

**0**

votes

**1**answer

808 views

### Excel scatter graph line only “connects data points with line” even with #N/A in source cells?

Excel scatter graph line only "connects data points with line" even with #N/A in the source cells. I have tried using different scatter graph line types but all interpolate the data over the ranges ...

**1**

vote

**1**answer

4k views

### Creating a 2D chart in excel with 2 Y-axes - one stacked, one non-stacked

I'm looking to create a 2D line-chart in Excel 2007.
It will have 2 Y-axes. The X axis will be dates.
There will be 5 series. I want 3 of the series to be stacked and use
one Y-axis, and the ...

**0**

votes

**1**answer

522 views

### Unix tools for plotting 2D graphs on Mac OS X

What are the available Unix commands for plotting a 2D graph on Mac OS X? XMGRACE, GRACE don't work on my laptop.
Can I download these packages?

**2**

votes

**2**answers

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

**0**

votes

**1**answer

4k views

### Copy chart from Calc spreadsheet to Writer document without linking in Libreoffice?

I've copied a chart in one of my Libreoffice 3.4.3 Calc spreadsheets into a Writer document in Mac OS X 10.6.8. However, I've noticed that the chart in the Writer document is linked to the one in the ...

**2**

votes

**1**answer

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

**2**

votes

**1**answer

2k views

### Application to generate graphs from MySQL table

I am looking for a solution to generate graphs from MySQL tables (local MySQL server).
I would like it to work on Windows, and not be based on a server (like a PHP server). This is just basic stuff: ...

**-1**

votes

**1**answer

2k views

### Prevent text wrapping in data table (Excel charts)

Is there some way to prevent text wrapping of long headers with no spaces in the data table of a chart?
I was hoping to find a "Shrink to fit" feature, like the one that can be applied to cell ...

**3**

votes

**1**answer

16k views

### Plot 2d graph in Excel

I have data in three columns, one for the x axis, one for the y axis and one actual data as:
X Y Value
0 0 1,005155
0 1 2,051385
0 2 1,15305
...
1 0 1,112285
1 1 1,48512
1 2 ...