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

learn more… | top users | synonyms (3)

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
761 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
449 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
10k 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
18k 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
4answers
60k 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
739 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
623 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
236 views

Gantt chart drawing tool

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 ...
1
vote
2answers
2k views

Excel 2010, Consolidating Category Axis in Pie Chart

I am working on a very basic "home budget" spreadsheet, to quickly see: A) how much money is left after the bills are paid and B) what % of withdrawals are going to what categories of expenses. I ...
0
votes
1answer
376 views

How to create graphs in Excel 2007?

I have data in CSV format, and I want to create a few graphs. I was looking around in google for how to do that, but it seems like most help about Excel graphs does not match my version of Excel ...
3
votes
1answer
22k views

Excel 2010: Can I hide columns without excluding the data from a graph?

In Excel 2010, is it possible to hide columns but still have the values show up in a graph? I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the ...
1
vote
1answer
1k views

Excel graph: turn stacked bar chart into part bullet chart

I've a simple data file that has one column of actuals and another of target against categories. I would like to turn the TARGET figure into a 'Bullet marker'. I've seen it done on other graphs but ...
2
votes
2answers
230 views

Processing RAW data to make a web displayable graph

I have data on a Linux system, about 44K data points, that I'd like to make a Scatter plot. The plot should be saved so that it can be displayed on a website (JPG?). Some other parameters: X-Axis: ...
1
vote
2answers
424 views

Graphing connections per second in excel

I have an Excel 2010 file like so: date time connections 2010-10-18 08:20:00 38 2010-10-18 08:20:01 71 2010-10-18 08:20:02 67 I want a line graph with the number of connections as the y ...
4
votes
3answers
2k views

Creating map of countries colored using country statistics

I want to create a PNG (or GIF) image, with geopolitical map of countries, where each country has color set according to some country statistics (e.g. 'USA' has n, 'Canada' has m, etc.). Something ...
2
votes
2answers
3k views

Calculate the Y Axis interval for a chart

When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval? I've been looking at Excel which seems to choose nice intervals like ...
2
votes
2answers
4k views

Placing labels on data points in a stacked bar chart in Excel

Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel? I am trying to modify the timeline template available here so that my labels for ...
1
vote
1answer
422 views

Tools to plot time-series data

I have a time-series dataset that looks like this (a few thousands of entries spanning for a couple of years): timestamp <TAB> items_added <TAB> items_removed For example: 1286016527 ...
5
votes
1answer
956 views

How to cancel tedious Excel charting operation without crash

I'm charting about 17,000 data points in Excel. Needless to say charting is slowwww. I accidentally selected the wrong chart type (Bubble thing?) and it is loading forever. I did not save my last ...
8
votes
4answers
24k views

Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to ...
3
votes
3answers
3k views

Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 ...
2
votes
1answer
995 views

How do you set a variable Y-axis min/max?

I have a colleague who creates lots of charts. He wants the min/max of the Y-axis of a bar chart to reflect the min/max within a range in Column "A" of an Excel spreadsheet. The min/max will change ...
2
votes
2answers
1k views

Visualizing document citations in a graph

Is there any tool which draws a citation graph for a group of related papers? (it doesn't matter the format of papers - PDF, Word, etc - it also doesn't matter if the software doesn't perform parsing ...
3
votes
3answers
3k views

Excel Graph: how can I show two values in the same bar? Not using stacked?

I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...
1
vote
2answers
1k views

Excel charts in PowerPoint 2007 are not editable by PowerPoint 2003

I'm trying to save a PowerPoint 2007 presentation which includes a chart copied from an Excel 2007 sheet in 97-2003 format but the chart is no longer editable by Office 2003 since it's automatically ...
0
votes
1answer
213 views

Excel Formula: trouble with the low % values not showing up in an in-cell chart? (image included)

I've a few tables that have % values like -4.5%; -16%; 15%; 6%; 2.5%. I'm interested in creating some in-Cell charts that show positive and negative values. My smaller values aren't showing up, so ...
11
votes
2answers
99k views

Excel chart with two X-axes (horizontal), possible?

Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ? I want to use the second axis to plot the normalized value of the default horizontal axis. ...
0
votes
1answer
775 views

Graphing Time in the Y-Axis creates duplicate entries?

I'm trying to create a graph based on Times and Dates and the Times on the Y-AXIS are being created with duplicate values. I attached a screenshot with the problem, the 0:00 can be seen twice. Does ...
0
votes
1answer
136 views

Trouble Making a Graph in Excel

I have two columns of data: Time Taken: 00:00:42.1093750, 00:00:09.5468750, 00:00:47.2656250, 00:01:27.6718750 Start Time: 21:02:27, 21:33:16, 22:03:27, 22:34:19 I want to make a cluster graph ...
3
votes
1answer
747 views

Excel 2007 Chart - Super Simple Chart what am I doing wrong?

I have two columns. The first column begins with "Year" followed by well years (1999, 2000, 2001, etc.). The second column has a title of "Revenue" and is contains revenue values ($12.1M, $13.2M, ...
1
vote
1answer
56 views

low-latency charting?

Need to deliver real-time charts (mostly bar and line charts) and wondering if a fast library can help. I guess that C is mandatory for speed and I would favor frame-buffer drawing (rather than a ...
2
votes
2answers
1k views

Excel: ROUND() to the next unit of 5?

I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5. ...
1
vote
1answer
702 views

Excel graphs: MIN/MAX axis scaling isn't working correctly

I have lots of graphs which I need to compare against each other. Therefore, I need a common scaling along the vertical (Y) axis. I'm encountering problems when pasting in my MIN/MAX series, and then ...
2
votes
1answer
2k views

Excel graphs: How do I apply a graph template format?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...
3
votes
5answers
9k views

Extract a graph legend and place it on the worksheet itself?

I have 8 graphs all with the same legend (line colours and meaning), so in order to save space I would like to remove the legend from each graph and create/include just one large one at the top of the ...
1
vote
2answers
225 views

What software created this graph?

Can anyone recognize what software could have been used to create a graph like this? I'm looking for something that could produce the same type of arrows.
3
votes
2answers
4k views

Excel: Pie Chart of a Question with Limited Possible Responses

I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. ...
1
vote
1answer
273 views

Pie Chart in Excel

I tried to google this but no luck. It is easy to add a pie chart when you have prcentace data but what if you just have a list of partially repeated data? For simplicity imagine there is a table in ...
1
vote
0answers
389 views

How to plot this in iwork-numbers

I have an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I have another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from ...
1
vote
1answer
561 views

Is there a program to calculate fibonacci charts and their continuations?

I'd need a program able to take data and plot a trend graph, and it should be able to continue it to see the future trend. I've found some commercial programs but none work. Is there a free one? I ...
1
vote
2answers
11k views

Excel bar chart - how to make axis as time scale

My data has column 1 = date (date format), column 2 = quantity (number format). The data looks like: date qty 1/3/2010 5 2/3/2010 2 2/4/2010 3 2/9/2010 1 4/13/2010 5 5/31/2010 5 ...
2
votes
1answer
668 views

Plotting the volume of an audio file

Most applications that play sound display its volume graphically. I need that information (the sound volume as it changes over time) written to a text file so I can plot it myself and use it for ...
1
vote
1answer
446 views

How can I turn data below in to a 'time based' graph

In my spreadsheet I am collecting time periods when certain values have been changed. The user is restricted to 4 time periods. I would like to show the data based on those time periods. I've ...
1
vote
2answers
1k views

Excel 2007 Pivot Tables: Overlapping issue hampers my summary sheet

I've created a Workbook that has 5 Pivot Tables (PT). I want to make a summary sheet that holds all these PT's, but when they expand the 'not allowed to overlap issue' causes me updating problems - ...
0
votes
1answer
675 views

Graph plotting software that includes the min() and max() functions

I am looking for online or offline software that can plot functions that include min() and max(). Neither of my favourites, Wolfram Alpha and fooplot seem to have these functions built in :-(
0
votes
1answer
1k views

Timeline chart in Excel

I'd like to see a timeline of events from a database in a "timeline chart", that should look like this: I've made me a small c# program that paints this onto a Bitmap, but that isn't the way to ...
1
vote
2answers
925 views

How to get scrolling plot in Linux (using command-line tools)?

Supposing I have a program that prints lines with data periodically, how can I turn then info them into graphical plot that updates itself each time new line available? $ ./prog 10 44 20 66 30 55 40 ...