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

**1**

vote

**1**answer

780 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

358 views

### How to have Excel chart connect data points when no value?

I'm charting daily values using a line chart. On some dates, I don't have any data. I would like the chart to connect the data points for which I have data across any gap in data.
So for example if ...

**2**

votes

**1**answer

3k views

### How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example:
Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart.
Is it ...

**0**

votes

**1**answer

125 views

### How can I create an automatically updating chart from a different worksheet with blank spaces in excel 2010

I have a worksheet that lists every day so I can see if any tests were performed that day. If there were tests, then the average and standard deviation of that day show up in the next two columns. I ...

**1**

vote

**1**answer

633 views

### Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...

**6**

votes

**4**answers

540 views

### How can I make a pictograph?

How could I make a chart similar to the one below?
Of course, I could use an app like Microsoft Paint, but that would be too time-consuming and awkward. What would be a simple way to do this?

**0**

votes

**1**answer

448 views

### How do I create bar charts with ranges as the x-axis in Excel 2010?

I am trying to create a bar chart for say some data, say for example
1 1 2 2 3 4 5
I want to create a bar graph so each bar shows the frequency of a range. For example, the frequency of a value ...

**0**

votes

**0**answers

111 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

**2**answers

487 views

### Excel 2010 line chart; limiting data points to fewer than the max

In Excel 2010, how do I limit the number of data points on a line graph to the latest (or last) 4 data?
I update the spreadsheet often, but only the latest data is graphed and reported.

**0**

votes

**1**answer

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

**1**

vote

**1**answer

337 views

### Chart Categories: How To Combine X-Axis Categories

The Task
I'm putting together a dashboard wherein I'm building several charts. I've attempted to use a pivot chart (2D line chart) to pull data from two different pivots (with the same source data). ...

**0**

votes

**1**answer

123 views

### Excel stacked column chart with unconventional data set

I'd like to create a stacked column chart based on the following set of data:
Region Segment Value
EMEA Premier 20
EMEA Standard 10
Americas Premier 30
Americas Standard ...

**0**

votes

**1**answer

420 views

### Line chart from multiple tables in Excel 2013

I have two sheets, "Graphs" and "Data".
In "Graphs" is a line chart with a single line that gets X and Y values from tables in "Data". I want the chart to be updated automatically when I add ...

**0**

votes

**1**answer

68 views

### Excel: resize chart sheet

I can create a chart sheet in Microsoft Excel 2010. I wish to resize the chart so that the proportions fill my wide screen. I right-click the chart and select Format Chart Area. Then I select the Size ...

**0**

votes

**1**answer

554 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

**0**answers

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

**1**

vote

**2**answers

3k views

### Drawing a line graph in Excel with a numeric x-axis

In Microsoft Excel 2010, I'm trying to draw a line graph with three different lines. I've got the graph looking the way I want, with one exception: Excel is treating my X-axis column like text ...

**0**

votes

**0**answers

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.

**1**

vote

**1**answer

240 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?

**0**

votes

**1**answer

1k views

### How to combine Excel charts on same X-axis

I want to create two stacked graphs in one chart object. One should be Stacked Column, and another Stacked Area. They represent revenue per partner per week of the year. On x-axis are weeks of the ...

**0**

votes

**0**answers

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

**2**

votes

**1**answer

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

**1**answer

548 views

### Add custom forecasting line in Excel Charts

I got the following graph (in purple):
I want to add the dotted forecasting line.
It's a cell value, but not referenced to the point on the X-Axis (Oktober 13).
I'm a bit lost as to how I could ...

**2**

votes

**2**answers

181 views

### Three pairs of box whisker plots in one coordinate system

I need to plot in Excel 2007 something which looks like this:
Basically I want to plot 2 box whisker plots, then have some empty space and then again 2 box whisker plots, followed by empty space ...

**1**

vote

**2**answers

180 views

### Average using Elapsed Time processing a number of docs

I process documents and want to get a formula showing the average time to process each document.
Here's my data:
number of docs processed (column G)
start date/time (H)
end date/time (I)
elapsed ...

**0**

votes

**1**answer

482 views

### Scatter chart series with uneven data intervals

I have two series of data I wish to plot on the same graph: Series 1 has 10 data points, Series 2 has 15 data points.
I want to show both series on the same chart (presumably Scatter) with the points ...

**2**

votes

**1**answer

2k views

### Filtering A Graph of Series Data In Excel

So I currently have a line graph with 48 different lines, comparing 48 different series of data. The series are generated by changing three variables: One with two possible values, one with 4 ...

**-1**

votes

**1**answer

694 views

### Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this:
It might ...

**0**

votes

**1**answer

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

**2**

votes

**0**answers

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

**3**

votes

**1**answer

8k views

### How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...

**1**

vote

**0**answers

129 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

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

**2**

votes

**1**answer

4k views

### A sensible way combine two stacked bar charts in Excel?

I have one chart that has several stacked bars with identical components - one for each category.
Each of the components of those bars can also be represented with a stacked bar chart, like the ...

**2**

votes

**2**answers

947 views

### Excel Scatter Chart with category based formatting of points

I have some data which I would like to plot in the scatter chart in the following format
date, category, value
01-Jan,Cat1,0.03
01-Jan,Cat2,0.13
01-Jan,Cat3,0.27
01-Jan,Cat4,0.32
...

**0**

votes

**0**answers

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

**3**

votes

**2**answers

972 views

### How to make a chart that graphs frequency of entries?

I have an Excel workbook that has nothing but dates (sorted), in the following manner:
11/14/2011 11:53
10/14/2012 11:53
11/23/2012 19:28
12/24/2012 12:27
...
12/1/2013 11:48
I would like to create ...

**0**

votes

**2**answers

85 views

### Embed Excel Charts into Powerpoint Issue

I am currently experiencing an issue with powerpoint 2010. I have created a three part chart in Excel and am trying to export it to powerpoint. However whenever I try to paste special the excel as an ...

**2**

votes

**1**answer

238 views

### Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.

**0**

votes

**1**answer

644 views

### How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis.
For example, I imagine the questions ...

**1**

vote

**1**answer

317 views

### Create a excel chart only with axis

I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100
Is this possible? If so how to do it?
...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

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

**3**

votes

**1**answer

9k views

### Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars.
...

**1**

vote

**1**answer

966 views

### Excel error bars based not on the graph data, but a separate set of error measurement data

I have several data sets, each of which includes several tests. Each test contains several temperature samples at different locations. For each data set, I have an average of the different tests for ...

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

**1**

vote

**2**answers

2k views

### Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0.
I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10:
30, 20, 10, 0, -10, -20, -30
I have set set ...

**1**

vote

**1**answer

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