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

**2**

votes

**2**answers

4k views

### Excel graph - two lines, one axis with date

I want to make Excel chart that shows my accounts' balances in time.
I have 2 bank accounts and I have all transactions saved in Excel. The data's format is:
Column A Column B Column C Column ...

**1**

vote

**1**answer

691 views

### How can I break external links in PowerPoint 2007 but keep the charts editable (not images)?

I have created a few charts in an Excel file and then pasted them as links into PowerPoint (PPT). Whenever I update the excel file, PPT updates automatically.
However when I break the links, the ...

**1**

vote

**3**answers

10k views

### How do I get a chart in Excel to add new data series automatically?

I am working on some charts for financial reporting. One of them shows some values for individual companies.
I will need to add new companies on a monthly basis, and would like the diagram to ...

**1**

vote

**3**answers

3k views

### Real-time graphing application for SQL data

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...

**1**

vote

**0**answers

412 views

### Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25

**0**

votes

**1**answer

258 views

### Excel Different line graph loaded on each selection

I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, ...

**0**

votes

**0**answers

66 views

### Programs for reading data off interactive web charts

This question is in the same vein as this one: Program for reading data off scanned graphs
Recently more and more interactive charts show up on the Net. Have a look at the following one:
...

**0**

votes

**1**answer

358 views

### Excel per-point custom error bars

I am attempting to draw error bars on a multiple bar graph in Excel 2007, and I am having trouble with the custom error bar minimum value. First, I created the graph from multiple series, then I ...

**0**

votes

**1**answer

940 views

### X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...

**2**

votes

**2**answers

25k views

### Easily Plotting Multiple Data Series in Excel

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...

**1**

vote

**2**answers

3k views

### Change the Point Color in chart excel VBA

I'm trying to the get the points from a chart in excel vba? I made a chart of student marks in excel, and I want to put a condition i.e if marks on chart are greater then 90 then the point color ...

**0**

votes

**2**answers

581 views

### Date axis with a partial year

I have a line chart with data spanning from February 2002 to today. At the moment, the date axis looks like this:
Is there a way to have the first date be Feb-02 (no change), but the next one be ...

**2**

votes

**3**answers

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

**-1**

votes

**1**answer

72 views

### Is there a tool to get data from a pie chart instead of the other way around?

I'm looking for a tool that helps me creating an investment portfolio. I'd like to decide the percentages first, and then the tool would output quantities. Also, percentages should be hierarchical. ...

**0**

votes

**2**answers

151 views

### Create Excel pie chart from choice placement

I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...

**3**

votes

**2**answers

4k views

### How can I plot a grouped histogram with LibreOffice Calc?

I would like to produce a grouped categorical histogram with LibreOffice Calc.
With grouped I mean an histogram with N columns instead of a single one for each category.
Something like this:
Any ...

**0**

votes

**1**answer

166 views

### Formula in Excel graph

I am creating a line graph in Excel 2007. What I would like to achieve is to specify a formula in the chart data range.
What I have now in the chart data range is:
...

**1**

vote

**2**answers

568 views

### Looking for PHP memory/CPU graph generator [closed]

Basically, that's what I'm looking for. I want an app that makes a live graph of the server's CPU and RAM usage. Is there anything like this?

**1**

vote

**1**answer

919 views

### Excel - set data range for multiple charts

I have a 'dashboard' of weekly stats - with week numbers in the columns across the top, and about 70 metrics in the rows.
I want to create around 20 charts from these different metrics, but always ...

**3**

votes

**0**answers

577 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

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

697 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

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

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

546 views

### Free/opensource application for charting stock prices? [closed]

I am looking for a free or FOSS software application for SIMPLY charting stock prices. I am not interested in any of the other nonsense typically bundled with such packages (technical analysis, back ...

**0**

votes

**0**answers

196 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

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

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

723 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

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

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

387 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

510 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

393 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

83 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

108 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

348 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

3k views

### Excel chart does not show all line feeds

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

**4**

votes

**2**answers

641 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% ...

**5**

votes

**1**answer

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

**1**answer

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

490 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

68 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

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

348 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

139 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

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