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

**3**

votes

**0**answers

555 views

### Create line graph with embedded horizontal histogram

How do I create these kinds of graphs:
with the horizontal histogram counting the number of times the left graphs go through a certain range?
I have access to Microsoft Excel and R.

**2**

votes

**0**answers

256 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

89 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

67 views

### Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its ...

**2**

votes

**0**answers

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

**1**

vote

**0**answers

22 views

### how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales.
First data set displays fine (left Y axis scale)
Second data set displays fine (right Y axis scale)
However when I try to ...

**1**

vote

**0**answers

54 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**1**

vote

**0**answers

48 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

134 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

166 views

### Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed.
I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...

**1**

vote

**0**answers

167 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

385 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

369 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

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

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

**1**

vote

**0**answers

382 views

### How to plot this in iwork-numbers

I have an array of data like this
0,1
0,56
0,4
0,57
0,6
0,006
0,34
0,46
...
I have another array of data that classifies the data above in categories like this:
from 0,1 to 0,5 category A
from ...

**0**

votes

**0**answers

8 views

### How to make Excel scatter plot axis show months rather than days?

I have an Excel scatter graph that is separating months into 20-day segments instead of the entire days of each month. How do I fix this? I want to have it reflect the days of the month by simply ...

**0**

votes

**0**answers

12 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**0**

votes

**0**answers

14 views

### Export animated PowerView scatter chart from Excel

I recently discovered the wonderfully cool capability of Excel to do an animated timeline akin to the type created by Hans Rosling (see his remarkable TED Talk The best stats you have ever seen as ...

**0**

votes

**0**answers

29 views

### Multplie Series Scatter Plot

I need to plot multiple series from one table, all of the series on the same graph.. So when I add new data to the table I don't have to reselect all the series for the appropriate graphs. I would ...

**0**

votes

**0**answers

16 views

### Percent Completion Pie Chart in Apple Numbers

I want to create a pie chart in Apple Numbers with two data sources. I want the percent completion of a goal. Let us say the goal is 4 and so far we completed 1. I would like to have both 1 and 4 ...

**0**

votes

**0**answers

17 views

### Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...

**0**

votes

**0**answers

26 views

### excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps ...

**0**

votes

**0**answers

11 views

### Displaying data correctly in a chart Word 2013

On the horizontal axis on this graph, I only have data for 1, 5, and 25. I want the graph to display as if i had 25 values and have the data show it respectively.
For example, instead of reading
1 ...

**0**

votes

**0**answers

51 views

### PowerPoint 2010 - Electrocardiogram -like chart

I need to make a chart in PowerPoint (PowerPoint 2010) that is like an electrocardiogram, actually is a chromatogram, I'm trying with line charts but I can't get the "peaks" of the line. I mean, in a ...

**0**

votes

**0**answers

30 views

### Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows.
Using this data, I have constructed a simple 2D line graph which I am fairly happy with.
The issue that I'm having ...

**0**

votes

**0**answers

11 views

### How do I configure the plot area to display my entire series of data?

The simplest way to describe my question is to view this image:
When I click on the series (i.e. the bars, you can see that the "shadows" of the non displayed bars are displayed outside the plot ...

**0**

votes

**0**answers

61 views

### Excel 2010 Chart Not Printing To Size

I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the ...

**0**

votes

**0**answers

307 views

### how to get exact value from Y axis and X axix for any point in chart

I have a chart with line graph. now for a particular point on the line how can i get the exact co-ordinates from Y axis and/or X axis.
For example if the major unit on Y axis is 200 and Minor unit is ...

**0**

votes

**0**answers

23 views

### Plotting two data sets with measurements at different scales

I'm doing research on a rock core with tools that measure different things over different lengths. One will give me a reading every foot , the other will give me a reading every 2in.
I am trying to ...

**0**

votes

**0**answers

189 views

### Lines over data in Excel 2013 Scatter Graph

I'm having some problems getting the plot order in a Excel 2013 scatter plot right. One series should have markers ("raw data") which should appear below series with markers and line ("fit"). The ...

**0**

votes

**0**answers

70 views

### Organization charts in Visio 2013

I am creating an org chart in Visio 2013 from an excel file . I have linked external data to shapes so I see the external data at the bottom of the screen. If I change the external data in excel and ...

**0**

votes

**0**answers

30 views

### 2d density graphs with R

I would like to plot a 2D density plot using R. I have a 2 dimensional data and would like to plot it in such a way that the dense part (with data points) of the graph is represented as red and less ...

**0**

votes

**0**answers

261 views

### Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data:
-0.0892 8
-0.0711 16
-0.0529 19
-0.0348 13
-0.0166 5
0.0015 12
0.0197 5
0.0378 5
0.0560 3
0.0741 4
0.0923 5
0.1104 1
I would like to add a ...

**0**

votes

**0**answers

83 views

### Plot 3 y axis in excel

I'm trying to plot three axes on the same graph. My data headings are: date/time (x axis), water level, temp, trout up, trout down.
I've seen examples where this is possible but don't know how to do ...

**0**

votes

**0**answers

11 views

### How to format the number category in chart tags?

Hello fellow Excel users:
I have 3 desktops at home. One has Excel 2007, other one Excel 2010, and the last one Excel 2013.
As a heavy Excel user, I prefer to have 3 different versions in order to ...

**0**

votes

**0**answers

146 views

### Excel 2010, how to show percentage values on clustered columns chart?

I was looking for a better way to do this but no luck googling. My problem is about showing numeric values and percentage value in clustered column chart. When I use pie chart, there is an option to ...

**0**

votes

**0**answers

146 views

### conditional formatting of pie chart segments

i have a very simple pie chart - developed in excel for mac 2011.
each segment of the chart represents a 'group' and is sized relative to a column of data called 'count'. there is a second column ...

**0**

votes

**0**answers

96 views

### Embedded excel chart in powerpoint does not print correctly from Office 2013

We have a user that has Office 2013 installed in her machine - she is the only one. The rest of the users have Office 2010. The user with 2013 is the only one with the issue.
There is a powerpoint ...

**0**

votes

**0**answers

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

158 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

121 views

### Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...

**0**

votes

**0**answers

283 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

288 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

336 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

193 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

77 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

66 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

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