Help on questions about graphs, charts and other graphical methods to show data.

**0**

votes

**1**answer

462 views

### Boxplots in Excel

Excel does not come with boxplot charts.
What is the best technique to simulate boxplot charts in Excel?
I'm interested to
draw horizontal and vertical charts
display the mean in addition to the ...

**1**

vote

**0**answers

68 views

### Keep values for grouped or hidden cells in graph? [duplicate]

Possible Duplicate:
Excel 2010: Can I hide columns without excluding the data from a graph?
I have a graph based on data contained in cell columns that can be grouped. Whenever I collapse ...

**0**

votes

**1**answer

17k views

### How to graph 3 different lines in the same graph with Excel?

I want to draw 3 line graphs on the same graph (to compare the data). They share the same x axis, and use the same data for the y axis but with different values. How can I do this? It's not working ...

**3**

votes

**3**answers

322 views

### How make this graph in Excel?

I'm trying to do this kind of graph in Excel, but nothing so far.
I don't find anything like it, but it has to be this way, not bars.
starter 22,58 20,76 7,1 37,93 68,42
...

**-1**

votes

**1**answer

136 views

### Excel 2007 plot with labeled data items

I have data in the following format, where each label defines a row of data:
label1 x1 y1
label1 x2 y2
label1 x3 y3
label2 x1 y1
label2 x2 y2
label2 x3 y3
This is a very large data ...

**0**

votes

**1**answer

508 views

### On a bar chart showing value gains in time frame, what is the easiest way to show losses?

I have a chart as on image below:
The red part of these charts are loses – values which should be subtracted from the overall amount. Is there any way that I can both show them on the chart and ...

**3**

votes

**2**answers

16k views

### Excel - stacked bar charts with two pairs of 'overlaps'

I'm trying to do some 'stacked' bar charts in Excel 2010 - here's a close psuedo example.
Team Buying target Buying result Selling target Selling result
Team A 80% 50% 70% 90%
...

**1**

vote

**1**answer

2k views

### Bar chart in Excel 2010 with values over maximum

How can I make a chart like this in Excel 2010?
Image from: EPA.gov
I have data where two out of 20 values are disproportionately large. In order to create a useful chart I'd like to cut out a ...

**0**

votes

**1**answer

116 views

### How to chart different shifts run times in Excel 2003

I have the following as an example.
Date Duration Shift
4-Dec 60 1
4-Dec 40 2
5-Dec 45 1
5-Dec 55 2
5-Dec 30 3
I am trying to map these ...

**0**

votes

**1**answer

2k views

### Excel x-axis scale [duplicate]

Possible Duplicate:
Excel axis problem
I jumped from an older version of Excel to the new ribbon interface and am stumped trying to make a simple graph.
I have a set of pair values that go ...

**1**

vote

**4**answers

10k views

### Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart?
I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...

**0**

votes

**0**answers

703 views

### Excel 2007 adding mean value and variance to histogram

I have to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range).
Example:
Data:
a,b,c,d,...
...

**1**

vote

**1**answer

939 views

### Record CPU usage then create Excel line chart with “Series” Column

I need to create a line chart to display the cpu usage of each process over time. How do I create the chart with time as the X axis, %CPU as the Y axis, then use the command name to indicate which ...

**1**

vote

**1**answer

258 views

### Advanced graph in Excel

This is my data:
Date Electricity Electricity2 Electricity3 Water Oil level (cm)
2011-06-30 8508 16041 7521 794 /
2011-07-10 8568 16170 7601 800 ...

**0**

votes

**1**answer

2k views

### How do I create this clustered column chart in Excel?

I have a data sheet split into three tables (one for each level). Within each table, there are four columns based on the answer (positive, neutral, negative, or N/A) and then there are six rows, each ...

**3**

votes

**2**answers

329 views

### Simplest Automated Analysis and Chart Generation Tool?

Are there any products that can take a CSV of info, and quickly generate commonly-asked for info? I'm wondering if there's any way easier than pulling this into Excel or Matlab and manually doing all ...

**2**

votes

**1**answer

1k views

### Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...

**0**

votes

**1**answer

577 views

### Excel scatter graph line only “connects data points with line” even with #N/A in source cells?

Excel scatter graph line only "connects data points with line" even with #N/A in the source cells. I have tried using different scatter graph line types but all interpolate the data over the ranges ...

**1**

vote

**1**answer

3k views

### Creating a 2D chart in excel with 2 Y-axes - one stacked, one non-stacked

I'm looking to create a 2D line-chart in Excel 2007.
It will have 2 Y-axes. The X axis will be dates.
There will be 5 series. I want 3 of the series to be stacked and use
one Y-axis, and the ...

**0**

votes

**1**answer

471 views

### Unix tools for plotting 2D graphs on Mac OS X

What are the available Unix commands for plotting a 2D graph on Mac OS X? XMGRACE, GRACE don't work on my laptop.
Can I download these packages?

**2**

votes

**2**answers

239 views

### Graph-like data editor tool?

Is there any unified editor program for creating, mainpulating and visualizing graphs, trees... or maybe any custom structured data. The accent is on editing, not visualization, i.e. not a drawing ...

**0**

votes

**1**answer

4k views

### Copy chart from Calc spreadsheet to Writer document without linking in Libreoffice?

I've copied a chart in one of my Libreoffice 3.4.3 Calc spreadsheets into a Writer document in Mac OS X 10.6.8. However, I've noticed that the chart in the Writer document is linked to the one in the ...

**2**

votes

**1**answer

482 views

### Scattergraph in Excel?

I am not sure if this is the right site, though here's my question:
I've been trying to make a scattergraph with Excel, but not getting the result I want. I have 2 data values for one thing. I don't ...

**2**

votes

**1**answer

2k views

### Application to generate graphs from MySQL table

I am looking for a solution to generate graphs from MySQL tables (local MySQL server).
I would like it to work on Windows, and not be based on a server (like a PHP server). This is just basic stuff: ...

**-1**

votes

**1**answer

1k views

### Prevent text wrapping in data table (Excel charts)

Is there some way to prevent text wrapping of long headers with no spaces in the data table of a chart?
I was hoping to find a "Shrink to fit" feature, like the one that can be applied to cell ...

**2**

votes

**1**answer

9k views

### Plot 2d graph in Excel

I have data in three columns, one for the x axis, one for the y axis and one actual data as:
X Y Value
0 0 1,005155
0 1 2,051385
0 2 1,15305
...
1 0 1,112285
1 1 1,48512
1 2 ...

**2**

votes

**2**answers

567 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

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

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

**1**

vote

**1**answer

4k views

### How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data.
However, some data is missing, resulting in zeroes in the calculated data which the chart uses.
When ...

**0**

votes

**1**answer

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

**8**

votes

**1**answer

33k views

### Create a pie chart from distinct values in one column by grouping data in Excel

I have an Excel document containing information from a survey. I want to create a pie chart over location (countries).
How can I make Excel group all the distinct values together and then display ...

**3**

votes

**1**answer

228 views

### Best way to visualize graph on a text console?

I looking for a solution to visualize a graph on a standard unix text console. Speaking more precisely I need to visualize a graph of dependencies between files from specified set, those dependencies ...

**1**

vote

**1**answer

5k views

### Excel: Charting date, time elapsed, and another value

I'm trying to chart growth in our nightly backups. The three values I'm using are the date of the backup, the backup job size in bytes, and the time the job took to completely in hh:mm:ss.
Using ...

**0**

votes

**1**answer

762 views

### Good chart drawing software? [duplicate]

Possible Duplicate:
Application to help build diagrams
I'm looking for a program, which I can use to draw good and smooth-looking charts. I would prefer it to be free, but it is another ...

**0**

votes

**1**answer

113 views

### Is there any free software to easily draw time-based graph?

or Excel template to draw something like below?

**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?

**2**

votes

**4**answers

12k views

### How can I create proportionally-sized pie charts side-by-side in Excel 2007?

I have a pivot table with two sets of data as follows:
2011 2012
Slice A 45 20
Slice B 33 28
Slice C 22 2
I am trying to present two pie charts ...

**2**

votes

**1**answer

371 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

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

**0**

votes

**1**answer

288 views

### Radial Density Plots

I am interested in making plots similar to those attached. Any recommendations on what software (or python code) to use? I suppose there are two things I would like it to do (although either one alone ...

**1**

vote

**1**answer

1k views

### Plot disproportionate values in single graph with Excel

I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One ...

**0**

votes

**1**answer

2k views

### Excel 3 dimensional stacked bar chart howto

One of our guys in the office wants to do a proper 3D stacked bar chart. In other words, he is not just interested in having a 3D rendering of the bars, but he needs full 3 dimensions for his data (x ...

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

**0**

votes

**0**answers

38 views

### Chart from groupings

Given such a spreadsheet:
col1 | col2 | col3
-----+------+----
alfa | foo | 10
beta | foo | 20
gamma| bar | 12
delta| bar | 42
I'd like to generate a chart grouping values from col2 and ...

**3**

votes

**2**answers

590 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

**0**answers

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

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

**1**

vote

**2**answers

328 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

**3**answers

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