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

learn more… | top users | synonyms (1)

0
votes
4answers
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
1answer
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
4answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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 ...