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

learn more… | top users | synonyms (1)

2
votes
1answer
45 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
1answer
360 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
1answer
148 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
1answer
879 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
1answer
128 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
1answer
37 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
1answer
321 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 ...
2
votes
0answers
102 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
0answers
69 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
0answers
57 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
0answers
157 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
0answers
559 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 ...
2
votes
0answers
464 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.
1
vote
0answers
30 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
0answers
48 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
0answers
124 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
0answers
139 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
0answers
292 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
0answers
317 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
0answers
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
0answers
221 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
0answers
375 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
0answers
4 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
0answers
18 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
0answers
24 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
0answers
9 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
0answers
25 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
0answers
20 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
0answers
45 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
0answers
27 views

Excel 2013 Chart - Multiple Series on Pivot Chart

I have an Excel 2013 file that pulls data from a SharePoint list. The goal is to create a dashboard that can be refreshed easily and without formatting or updating formulas of any type. The ...
0
votes
0answers
508 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
0answers
35 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
0answers
51 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
0answers
92 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
0answers
103 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
0answers
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
0answers
191 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
0answers
28 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
0answers
47 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
0answers
220 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
0answers
43 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
0answers
171 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
0answers
229 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
0answers
279 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
0answers
138 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
0answers
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
0answers
64 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
0answers
172 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
0answers
595 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,... ...
0
votes
0answers
37 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 ...