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

**2**

votes

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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 ...