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

**2**

votes

**1**answer

44 views

### X-axis changes Excel plot output

I have the following Excel file:
https://dl.dropboxusercontent.com/u/33532467/GDV_Prognose_Leben.xlsx
The green hatched area is not shown properly. I would expect:
The horizontal axis seems to ...

**2**

votes

**1**answer

334 views

### Constructing an annual cycle/radial diagram in PowerPoint

I would like to make a diagram like the below in PowerPoint, but I can't figure out how to draw the curved boxes (like the ones that say "Fishing" or "Trapping" in the chart).
Diagram
...

**2**

votes

**1**answer

143 views

### Custom area graph in Excel (or google spreadsheet)

I am trying to visualize my loans with area graph and have some additional needs/wishes.
For example - this is my data (made up):
house car mower vacation
diners ...

**1**

vote

**1**answer

74 views

### How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where:
Column A is filled with arbitrary dates sorted by increasing age
Column F has numeric data relevant to this question
Row 1 is the ...

**1**

vote

**1**answer

33 views

### Word: remove space before paragraph with picture

I'm writing a paper and adding charts surrounded by the text has been quite a pain. Currently I have one chart that sits in the top left corner of a page. There is approximately 4 cm left after the ...

**1**

vote

**1**answer

249 views

### How do I link to excel chart data in PowerPoint with relative paths?

This question is similar to the question posted in
How do I embed video in PowerPoint with relative paths?
But in my case I search for an answer to get Excel charts, which are linked in an absolute ...

**1**

vote

**1**answer

2k views

### Plot scatter graph in Excel graph with 3 variables in 2D

3 Columns of Data:
Date (from 1st till 31st)
Variable 1
variable 2
I want to make a simple graph where Variable 1 range is X axis and Variable 2 range is Y axis,
I plot the date on the graph ...

**1**

vote

**1**answer

85 views

### How to: edit data in excel, visualize it on a second screen whilst live?

Suppose I have the following set-up:
I have a laptop connected to a screen. The screen shows whatever. The screen is in front on an audience who are asked to choose between several alternatives, say ...

**1**

vote

**1**answer

293 views

### How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...

**1**

vote

**1**answer

172 views

### Color bands in bar charts in Microsoft Excel 2010

Is it possible to obtain a bar chart like the one in this example:
(that is: I need to have vertical color bands to make "visually" group the bars for each horizontal axis' point.)
Any ideas?

**1**

vote

**1**answer

130 views

### Expanding set of y axis values in chart, developed by MS-excel?

I have developed a chart from a set of values of excel file, Now what I have to do that I have to expand the y axis values from point 5 to point 8, Can anyone please suggest me that how to do that.
I ...

**1**

vote

**1**answer

320 views

### Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

It could be an easy question but I can't find a proper way to accomplish my task.
I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph ...

**1**

vote

**1**answer

534 views

### How can I break external links in PowerPoint 2007 but keep the charts editable (not images)?

I have created a few charts in an Excel file and then pasted them as links into PowerPoint (PPT). Whenever I update the excel file, PPT updates automatically.
However when I break the links, the ...

**1**

vote

**1**answer

658 views

### Excel - set data range for multiple charts

I have a 'dashboard' of weekly stats - with week numbers in the columns across the top, and about 70 metrics in the rows.
I want to create around 20 charts from these different metrics, but always ...

**1**

vote

**1**answer

450 views

### Free/opensource application for charting stock prices?

I am looking for a free or FOSS software application for SIMPLY charting stock prices. I am not interested in any of the other nonsense typically bundled with such packages (technical analysis, back ...

**1**

vote

**1**answer

444 views

### Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?

Google Docs has a nice trend viewer that can be created just like any other chart:
Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...

**1**

vote

**1**answer

591 views

### Excel 2003 charts not looking right in 2007

I'm not exactly sure this goes here but I don't know where else to look for help.
I have some Excel files containing charts made with Excel 2003. When I open the file in Excel 2007 and save it (non ...

**0**

votes

**1**answer

19 views

### Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application.
Below is the example of code that I'm ...

**2**

votes

**0**answers

54 views

### Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows
Mean values 61 43
Sample 1 0.009 0.059
Sample 2 0.108 0.099
Sample 3 0.043 0.038
...

**2**

votes

**0**answers

64 views

### Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...

**2**

votes

**0**answers

146 views

### MS Project 10 & 13 - Creating Custom Gantt Chart for Resource Allocation

I have created a very basic setup to better monitor staffing and scheduling decisions for my firm. Essentially, I create one task for each new project and assign the resources that will work on that ...

**2**

votes

**0**answers

539 views

### How to make a LibreOffice Calc XY (scatter) plot with named dots?

I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456").
I would like to know if I could have the content of a ...

**1**

vote

**0**answers

26 views

### Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right.
I have a Workbook.Open routine which will change to custom formatting (and back on ...

**1**

vote

**0**answers

33 views

### How to chart time of day in Google Spreadsheet with midnight crossover?

I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after ...

**1**

vote

**0**answers

134 views

### Excel scatter plot with multiple series from 1 table

Say I have a table as follows:
Label | X | Y |
A | 1 | 1 |
B | 2 | 2 |
B | 3 | 2 |
A | 4 | 3 |
C | 5 | 4 |
A | 4 | 3 |
C | 2 | 1 |
How ...

**1**

vote

**0**answers

127 views

### LO Calc: Why are data labels placement options greyed out?

When creating pie charts I like to add the values of the individual slices to the chart. LO Calc allows you to do this ('Add data labels') By default Calc places these values in the center of the ...

**1**

vote

**0**answers

269 views

### Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25

**1**

vote

**0**answers

301 views

### How can I change the default font size that is set on charts in a PowerPoint template?

As the title says I'm interested in knowing how I can change the default font size that is set on charts in a specific PowerPoint template.
I'm not interested in using chart-templates for this, since ...

**1**

vote

**0**answers

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

174 views

### How to get data series in Highchart from a JSON POST request (cross domain)

I'd like to create my own Highstock's chart on a local html file by using the JSON data series retrieved with a POST request to a third-party domain.
I've read several docs on Highcharts' website but ...

**0**

votes

**0**answers

25 views

### How to plot excel chart with multiple series from single data source

How do I plot the following multiple series information on a single chart:
DateTime SeriesName Duration
2014-05-02_10:21:21 X 2013.006
2014-05-02_10:21:22 Y ...

**0**

votes

**0**answers

43 views

### Excel chart copying whole sheet into a new workbook - references to hidden rows are copied as absolute link

When in Excel 2013 I copy and rename whole sheet containing a chart into a new workbook, my references to series value ranges, axis labels etc., that have data in hidden rows, are not copied as ...

**0**

votes

**0**answers

53 views

### Excel 2010 Pivot Pie Chart on Results Column instead of first column

my Pivot Pie Chart always displays the splits of the first column of the Pivot table.
I´d like to use slicers to chose the Periods in the pivot table
and then would like the Pie chart to adjust to ...

**0**

votes

**0**answers

94 views

### how can i capture a flash object thats displayed by the browser but the swf file is kind of protected, like on scribd

i want to download a stock's intraday price chart. its a flash object. dont know whether its protected in such a manner as to not allow it to be saved on to the disks of end users(like certain files ...

**0**

votes

**0**answers

50 views

### The Specified Dimesion is not valid for current chart type

I am trying to open a file into which I will copy the data from the previous file but I am getting an error while opening the other file.
Here is my code
Dim WSC, WSD As String
Dim Filter As String, ...

**0**

votes

**0**answers

163 views

### Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the ...

**0**

votes

**0**answers

26 views

### How can I add 2 charts without legends but data from two ranges in Excel 2013

How do you add 2 pie charts to the same worksheet with no legends but instead data entered from 2 different ranges?
If I add 1 pie chart I cant add a 2nd pie chart with data from 2 different columns.

**0**

votes

**0**answers

41 views

### Manipulating organization chart objects in PowerPoint 2007

I am working in PowerPoint 2007. I know if I am working with free form objects, I can align them, make one object the same width/height as another object, etc. But when working with org chart ...

**0**

votes

**0**answers

217 views

### Excel VBA updating graph data

I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...

**0**

votes

**0**answers

42 views

### How to use a variable end column in a SERIES (chart) forumula in Excel 2010

One of the series in my chart looks like this:
=SERIES('sheet1'!$A$13,'File.xlsx'!Xaxis,'sheet1'!$B$13:$S$13,3)
So what I understand is:
The first argument is the series name
The second argument is ...

**0**

votes

**0**answers

157 views

### How can I create a matrix chart with Excel 2010?

I want to create a chart where, if the value of a cell matches the criteria of both its row and column, I can mark it with a cross.
I could just type an 'x' into the cell, but I would like to find ...

**0**

votes

**0**answers

197 views

### How can I create a compound bubble and pie chart?

I'm looking for a way to create a compound bubble and pie chart likes this one:
I know that ManyEyes could do it, but I don't want to upload my dataset to the public. How can I accomplish this?

**0**

votes

**0**answers

111 views

### Visio 2010 Organization chart

I'm looking to build an org chart in Visio 2010 by using data from excel. There are many tutorials about this, so this part is pretty easy.
My question is, is there a way to create automatic ...

**0**

votes

**0**answers

269 views

### Excel Radar chart to visualize data

I have a set of data with which I want to produce a Radar chart for easy comparison.
This is just like an inventory list with A,B and C as the products list, I want to achieve the following :
...

**0**

votes

**0**answers

126 views

### Highlighting values in Excel pivot table or chart

Excel can prepare pivot charts and tables based on tabular data on an Excel sheet.
I am looking for a way to highlight sections of the pivot chart or table to easily see where a specific single ...

**0**

votes

**0**answers

74 views

### Excel 2010, changing on its own

Excel 2010 has began changing my chart tab names from the ones that I set, back to "chart 1" "chart 2", etc.
I went through and changed them all to what I had set again, and the next day they were ...

**0**

votes

**0**answers

61 views

### Programs for reading data off interactive web charts

This question is in the same vein as this one: Program for reading data off scanned graphs
Recently more and more interactive charts show up on the Net. Have a look at the following one:
...

**0**

votes

**0**answers

167 views

### How to apply Excel formula to datapoints for chart *without* helper column?

in Excel (2007 or newer) is there an easy way to apply any Excel formula on a set of datapoints before drawing a line/box/... on the chart, without using a helper column to do so?
(This is a ...

**0**

votes

**0**answers

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