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

learn more… | top users | synonyms (3)

2
votes
2answers
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
1answer
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
3answers
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
3answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
2answers
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
2answers
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
3answers
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
0answers
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
4answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
4answers
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
3answers
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
1answer
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
1answer
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 ...