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

learn more… | top users | synonyms (3)

3
votes
1answer
292 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 ...
1
vote
1answer
345 views

Excel - Create the same Charts Monthly

I've got a workbook with a table that has the months across the top. Each month, another month column will be added and the data for that month will be filled in. For each month, I want to create ...
3
votes
1answer
742 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 ...
1
vote
1answer
2k views

How to create excel line charts with irregular scales

I am trying to create a line graph, The vertical axis is an irregular scale - 1,1c,1b,1a,2,2c,2b,2a and so on. Here is the data in chart format I am having trouble representing this data in the ...
1
vote
2answers
424 views

All cells in column as graph source except header

I want to create a graph of all values in a column, except the first which is a header. I could do this by selecting the following as Series X Values: =Foo!$A$2:$A$8 Problem is that I'd have to ...
1
vote
3answers
9k 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 ...
0
votes
2answers
3k views

Excel Line Graph with columns and rows transposed

My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B ...
2
votes
1answer
174 views

Custom area graph in Excel (or google spreadsheet)

I am trying to visualize my loans with area graph and have some additional needs/wishes. For example - this is my data (made up): house car mower vacation diners ...
2
votes
2answers
5k 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
707 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
429 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
266 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
360 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
952 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
26k 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
585 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
153 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
172 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
578 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
934 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
589 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
703 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
10k 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
552 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
197 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
733 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
388 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
522 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
398 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
352 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
4k 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
659 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% ...