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

learn more… | top users | synonyms (3)

2
votes
2answers
579 views

How can I show a line chart in Excel (or Access) with category lines that ignore missing data?

I'm collecting data for various series (A-G), at sporadic intervals. I want a line chart, with one line for each series, that is connected even if there are intervals where no data was collected for ...
1
vote
1answer
363 views

Can you create dynamic named series for a chart?

I need a column chart which trends 6 month(I have this covered) but stretches rows based on values in the data set. I could hook the chart to the pivot BUT I need to summarize all values over a count ...
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 ...
5
votes
1answer
896 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 ...
1
vote
0answers
230 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 ...
2
votes
1answer
1k views

How to create a XY (scatter) chart with three columns of data?

I have the following data: Date Name Value 1/1/2011 FOO 10 1/1/2011 BAR 12 2/1/2011 FOO 16 3/1/2011 BAR 21 5/1/2011 FOO ...
0
votes
1answer
323 views

How to define an organizational hierarchy in Visio 2010?

How do you create the relationships between positions in a Visio 2010 Organizational Chart? I have created the chart, added several positions to the chart, and now I wish to define which positions ...
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
2answers
123 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 ...
1
vote
2answers
221 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.
1
vote
1answer
63 views

Downloadable map data usable in applications [closed]

I wish to create a small pathfinder application with maps. Where can I download navigation European map data and find documentation about their formats?
3
votes
2answers
3k 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. ...
2
votes
1answer
374 views

Excel distorting markers in scatter plot

I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For ...
0
votes
1answer
934 views

How can I make a bar chart in OpenOffice Calc where the bars have two different colors to signify two different types of products?

I'm sure most people have seen the Intel vs. AMD charts that places like TomsHardware.com use, but just in case you haven't, here is my chart: I want the PV bars in black, and the Solar Hot Water ...
1
vote
4answers
4k views

Best tool for creating organizational charts? [duplicate]

Possible Duplicate: Application to help build diagrams I need to find a Windows tool/software, or an online service, for creating organizational chart for the company I'm employed at. I ...
6
votes
2answers
26k 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 ...
3
votes
2answers
604 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
1answer
514 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
5k views

How can I create a pie-chart with gnuplot?

I want to create a pie-chart. Is that possible with gnuplot and how to realize that?
1
vote
1answer
986 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 ...
3
votes
4answers
10k views

Excel chart, how to make a formula produce gaps?

I have a chart in Excel 2007 that is basically just a line graph. Some cells that make up the series data cannot produce a value through their formula, and I'd like the chart to place a gap in that ...
1
vote
1answer
814 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 ...
0
votes
1answer
898 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 ...
2
votes
1answer
718 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. ...
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 - ...
7
votes
2answers
14k 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
200 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
5k 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
996 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 ...
0
votes
1answer
606 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
2answers
7k 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
2answers
678 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 ...
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
3k 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
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
212 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 ...
3
votes
1answer
714 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
251 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
2answers
836 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 ...
6
votes
3answers
13k views

Excel chart on one column of date/times

I have a list of date/timestamps, and I would like to plot these to a chart in Excel. What I'm looking for is a chart that shows "events per hour" or something similar. Can this be done easily if I ...
2
votes
2answers
492 views

Best software to build charts (pies, bars)

I am somewhat disappointed with Excel charts and short of building my own with a vector graphics too, is there something really awesome for charts?
0
votes
1answer
4k views

How can I set text wrapping on an Excel chart in Word 2007?

Title says it all realy. I'd like to apply square text wrapping to an Excel chart inserted into my document. The normal options don't seem to exist. Is there any way of doing this other than inserting ...
2
votes
1answer
7k views

Create two axis stacked columns chart in Excel

The data I'd like to chart is like this: 2000 2001 2002 A x x x B x x x C x x x D x ...
8
votes
2answers
20k views

What is the best free Gantt project tool out there? [closed]

I've gone through some of the other posts on superuser and some other online resources to find the answer to this question, but I'm not satisfied with anything I've found. Basically, I just need a ...
2
votes
1answer
3k views

Excel Chart X Axis Values

I'm trying to create a line chart in Excel with the following values from my sheet: (0,100) (1,90) (2,80) (4,70) (8,60) (16,50) The problem I can't work around is that I want the 0, 1, 2, 4, 8, 16 ...
1
vote
3answers
466 views

Creating Flowcharts in the Office Suite

I need to create a couple of flowcharts and I am wondering which of the Microsft Office products are best suited to doing so (Word, Powerpoint, Excel?). Do any/all of these have flowchart creation ...