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

learn more… | top users | synonyms (3)

3
votes
2answers
928 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
0answers
71 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 ...
7
votes
2answers
37k 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
2answers
350 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
3answers
61 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.
10
votes
2answers
27k 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 ...
2
votes
2answers
4k 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
2answers
4k 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
2answers
7k 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
1answer
118 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 ...
3
votes
1answer
570 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
3answers
7k 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
3answers
11k 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, ...
2
votes
1answer
4k 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
1answer
237 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 ...
26
votes
7answers
45k 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
3answers
3k 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
1answer
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
1answer
792 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
1answer
1k 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
3answers
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
1answer
168 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
3answers
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 ...
2
votes
3answers
4k 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
2answers
17k 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
1answer
212 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
1answer
539 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
2answers
33k 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
2answers
128 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
2answers
120 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
3answers
10k 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 ...
4
votes
1answer
2k 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
2answers
4k 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
1answer
956 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 ...
7
votes
3answers
45k views

Making line charts so the line goes through all data points

I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around? I've ...
0
votes
3answers
3k views

Annotating Graphs From Textual Data

I have a graph that was generated from a data set that contains: (date, value, annotation) The annotation is a constant value [its either there or is blank] and I would like to add in the third ...
1
vote
1answer
897 views

Excel Chart not displaying X Axis

I've got a chart in a spreadsheet in Excel 2010 which is using A chart = "Stacked Column in 3-D" I have defined the Horizontal (Category) Axis Label in the Select Data Source window and it is ...
1
vote
1answer
6k views

Prevent Excel Chart Data Labels overlapping

I have an Excel dashboard with line charts containing data labels. Specifically, we are only using the data labels at the rightmost end of the lines, and the labels consist of the Series name and ...
0
votes
1answer
1k views

Line chart with very small difference in values

I have data in excel that basically looks something like this: x264 VP8 Theora 0.99593 0.99328 0.96688 0.99497 0.99243 0.96646 0.99442 0.99180 0.96680 ............. and so on for about 4500 ...
1
vote
1answer
1k views

Excel 2007 bar chart auto axis

I am creating a bar chart with values ranging from 100 to 100,000. I keep the X axis as auto scaling allowing me to change the starting point. From what I understand, if two bars variance is greater ...
0
votes
1answer
776 views

How can I prepare a pie chart in excel with a result based on 100%?

I have the total I've earned last year which should represent the 100% of the pie. Then I have my insurance expenses and I want to understand, graphically, how much of my total income went to pay ...
0
votes
1answer
3k views

Excel 2010: Create Graph From List

I have created a drop down list for use in each row (for the purpose of categorising). I'd like to graph the selected data (i.e the column of drop down lists) into a graph, probably a pie chart. If I ...
1
vote
2answers
469 views

Grapher: Edit Equations Without GUI

I'm trying to edit the equation of a Grapher file without opening the Grapher UI. I've gotten as far as knowing that I need a hex editor to do this. I can't, however, find my equation in that file to ...
1
vote
2answers
11k views

Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this... Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...
0
votes
1answer
2k views

Excel 2010: How to color the area between charts?

I asked this question already on stackoverflow but it hasn't been answered yet. Instead I was advised to try it here, so here I go :) So there's that simple XY-Line-Chart in Excel (2010). It is ...
1
vote
4answers
19k views

How to create a Wind Rose plot in Excel 2007?

I am attempting to create a wind rose graph, i.e. My data is wind speed and cardinal wind direction in separate columns: Wind (mph) Wind Direction 3.66 SE 2.69 SE 2.62 SW ...
6
votes
7answers
67k views

How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, ...
0
votes
2answers
790 views

interpolation chart in excel

My data is about real estate lots: area and price. The data is not sorted. How can I create a chart so that I can see the correlation between area and price? For example for: 500 1,000,000 450 ...
0
votes
1answer
635 views

PowerPoint 2010 Chart Arrows

Summary: I have a powerpoint slide that I created, that when played it changes the direction of the arrows. Detail: I created a chart using Excel 2010 (Windows 7). I copied the chart and pasted it ...
1
vote
0answers
240 views

Gantt chart drawing tool [closed]

I need a Gantt chart drawing tool but on timeline I need my custom units (e.q. from 0 to 3000), not days or years. What tool alows to do that? Edit: Finally I have found no such tools. I had to make ...