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

**0**

votes

**4**answers

2k views

### Good (preferably free), easy to use, attractive flowchart software [closed]

While there is no shortage of awesome concept mapping or mindmapping software, I'm left rather cold by the offerings of flowchart related software or apps available.
I'm looking for something that ...

**0**

votes

**1**answer

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

**0**

votes

**4**answers

4k views

### My pivot chart has the wrong Y axis values but correct data point values

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values.
The values on resulting lines are correct (see the data label at the end of the line) ...

**0**

votes

**2**answers

45 views

### Excel Charts - How do i plot time on the Y axis

I am a keen runner and am trying to plot my progress on a chart using the following times
00:27:18
00:28:19
00:26:49
00:27:19
00:26:05
00:27:18
00:26:22
00:26:49
00:30:40
00:28:03
00:26:58
00:27:35
...

**0**

votes

**1**answer

68 views

### Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this:
2014-02-20 23:04:57.9263690 +00:00
2014-02-20 23:05:02.3117944 +00:00
2014-02-20 23:05:02.7490564 ...

**0**

votes

**1**answer

728 views

### Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form:
X | Y
----+-----
3 | 42
4 | 57
6 | 92
11 | 119
19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 ...

**0**

votes

**1**answer

254 views

### Offset the tickmarks of a secondary axis

I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that ...

**0**

votes

**1**answer

397 views

### How do I set one to many relationships in lucid chart?

I have connected two shapes with a line in lucid chart. How do I show that it is one to many? Visio allows you to do this.

**0**

votes

**1**answer

66 views

### excel chart: how to change data points format in part of the curve?

Suppose I have a curve of x(t), data points are shown as blue squres.
Is it possible to easily set it, so that when x(t) is less than 0, the point will be shown as red circle?
I know each data point ...

**0**

votes

**1**answer

362 views

### Scatterplot with variable X on X axis and Y on Y axis

I have a dataset with variable A (Age) and B (performance). I want to create a scatterplot with variable A on the X axis and B on the Y axis, but Excel is acting all weird with it.
I have approx 120 ...

**0**

votes

**2**answers

637 views

### Excel 2007 Stacked Column Chart Display Subvalues

So I have the following set of values in my excel sheet:
The values on the first column (very low, low, medium, high) are simply socio-economic layer indicators.
As you can see, everything is ...

**0**

votes

**1**answer

230 views

### What is the best flow diagram if you have multiple processes and projects tied together like so

I have used flow charts in school and in an attempt to create a less generic chart, I figured I will share the processes and data I wish to organize.. see what ideas are available for this complex ...

**0**

votes

**1**answer

221 views

### Excel PivotChart count rows where not blank

I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was ...

**0**

votes

**1**answer

108 views

### Excel 2010 charts from ungrouped data

I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such
Falun
Borlänge
Stockholm
Uppsala
Borlänge
Stockholm
...

**0**

votes

**1**answer

562 views

### How can I increase Excel's graph axis area?

This is what the x-axis of my graph currently looks like (Excel 2010):
The dates are in the format YYYY-MM-DD, but as you can see month and date are chopped off. I tried resizing (the dots at the ...

**0**

votes

**2**answers

4k views

### Is it possible to create a broken X axis in Excel 2007?

I'm trying to find a solution to a problem that I have with my data.
In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the ...

**0**

votes

**2**answers

453 views

### Date axis with a partial year

I have a line chart with data spanning from February 2002 to today. At the moment, the date axis looks like this:
Is there a way to have the first date be Feb-02 (no change), but the next one be ...

**0**

votes

**1**answer

79 views

### Comment a remarkable point in a graphic

I have a graphic like this one, based on dates/values:
Some points on the graphic represent special events, and I'd like to associate them with a comment, like: "Called the manager", "Strike", ... ...

**0**

votes

**1**answer

2k views

### Excel chart does not show all line feeds

I'm trying to set up an Excel chart. I've tried to enter 6 line feeds. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right hand side listing of feeds it shows the ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

717 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

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

**0**

votes

**3**answers

2k views

### Relative Gantt in MS project?

Is there a way to create a relative Gantt in MS project, that is a Gantt that doesn't have a defined start date, just amount of time required for each task?

**0**

votes

**2**answers

4k 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?

**0**

votes

**1**answer

12 views

### Chart not showing all data

I have created a very simple spreadsheet with data by half an hour for every day from Mon - Fri.
I have then created a line chart and in the legend every day is shown, however the data for Monday is ...

**0**

votes

**1**answer

22 views

### Microsoft Excel chart with dynamic series

I am working on creating a excel template file that includes charts generated from the data added. One of the charts displays trending data over 12 months for an unknown number of products. The ...

**0**

votes

**1**answer

81 views

### What are the labels for minor ticks in a log scale graph?

What are the labels for the minor ticks in a log scale graph?
I would like to label them. So, I want to know how to calculate the value for each of the minor tick.

**0**

votes

**1**answer

61 views

### How to create line chart in Excel with two series of ordinal/nominal data?

I have these two columns in Excel.
Result Speed
------ ----
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
MEDIUM HIGH
HIGH HIGH
HIGH HIGH
HIGH ...

**0**

votes

**1**answer

71 views

### Excel Chart from Multiple Sheets

I have a bunch of sheets and each one has a value in cell K15 and call K20. How do I make a stacked column chart that shows these values stacked for each sheet?
Forgive my crude drawing, but ...

**0**

votes

**1**answer

940 views

### How to plot negative numbers in Y-axis in Excel 2013

I have created a chart of Sales and Growth over a period of years... The growth is negative in a couple of years.
A normal combo chart with Sales in Primary Axis and Growth in Secondary axis looks ...

**0**

votes

**1**answer

53 views

### Excel coloured line chart for grouped data?

In Excel how do I create a line Chart with each simulator being its own coloured line showing Calculation time (and potentially another colour for its Total time).
Axis X = Rounds
Axix Y = Time ...

**0**

votes

**1**answer

1k views

### ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that?
Sub DeleteGraph()
Dim graph As ...

**0**

votes

**1**answer

67 views

### Custom Chart Axis

I have an Excel chart whose X-axis values are 5000, 10000, 15000 and so-on but I want them to be like 1,2,3,... i.e. divide them by 5000.
Is there any way I can accomplish this?

**0**

votes

**1**answer

124 views

### Column graph with multiple grouped values and one value above all of them as goal and with filled space between

I wish to create some kind of a special chart. I have 4 values, 3 are values measured over 3 years for state and the 4th is the goal where should it all go in future. The chart I want is a column ...

**0**

votes

**1**answer

222 views

### Scatter diagrams with group labels for X/Y coordinates

I'M trying to create a map layout from an Excel spreadsheet in Excel 2003.
I have x and y coordinates in columns as well as group name and place name. I tried using a scatter chart but I can only ...

**0**

votes

**2**answers

1k views

### How do I create a chart in Excel with dynamic series based on the data content?

How would I define a chart in Excel (2010) that shows a time series graph containing various series based on the data content itself? For example, here is a data set:
Date Series A Values
...

**0**

votes

**3**answers

857 views

### Putting a line feed in a string built in an excel formula in a data label

I need to construct a data label in an excel chart using a formula building the string from two cells with a line break between them.
This would work in a cell formula:
=A1 & CHAR(10) & B1
...

**0**

votes

**1**answer

150 views

### Excel X axis label

In Excel, I want the value of the data marker displayed at the right edge of the data marker. Ex: an amount representing 0-10 is graphed, and the 10 on the X axis is on the right edge of the column ...

**0**

votes

**1**answer

330 views

### Pull Data from Pivot Table to Grid on Different Worksheet

I am trying to make an Excel Workbook that contains the statistics of an XBox Tournament that our office is doing. Winner of the whole Tournament wins the XBox! It's fairly simple rules. Everyone will ...

**0**

votes

**1**answer

139 views

### How do I select a blocked chart in a Excel 2010 chart?

How can I select a blocked or protected chart in Excel 2010?
When I right-click on the chart, the cursor changes to a circle with a diagonal line within it - a "blocked" sign. I'm doing a study ...

**0**

votes

**1**answer

363 views

### Making chart from custom data format in Excel 2010

I am defining custom data format via Apache POI. I know I need to use following construction:
DataFormat data = this.workbook.createDataFormat();
...

**0**

votes

**1**answer

156 views

### What is the best way to graph this in excel

I have a table in excel with three columns:
Name
Start Date
End Date
I want to create a chart with count on the left hand side and date on the bottom to show the count of open item (defines ...

**0**

votes

**1**answer

139 views

### Excel Line chart multiple related series, colouring

I'm using MS Excel 2010.
I have a worksheet that looks like this
---/ 1001 / 1002 / 1003 / 1101 / 1102 / 1201 / 1202 / 1203 / 1204
R2 / ...
R3 / ...
...
I would like to create a line chart with ...

**0**

votes

**1**answer

685 views

### X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...

**0**

votes

**1**answer

135 views

### Create Excel pie chart from choice placement

I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...

**0**

votes

**1**answer

532 views

### Windows. Active X objects. Excel Chart

i need to find Excel active X object mschart.ocx or mschrt20.ocx.
Where are they laying?
Thanks!
P.S:
Am i right, that they can help me to use active x chart: msdn
Thanks!

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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