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

**2**

votes

**1**answer

4k views

### Make two or more graphs have the same scale

I have several area graphs in an Excel spreadsheet. I want all of those graphs to have exactly the same scale.
Each of the graphs have a measurement in meters on each of the axes. I want each of the ...

**0**

votes

**0**answers

281 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

55 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

950 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

945 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

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

288 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

1k 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 tables/...

**1**

vote

**1**answer

495 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

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

**1**answer

58 views

### Excel graph showing customer representation based on size of different businesses

I would like to represent in a graph the percentage of A, B and C customers in each business unit, taking into account the size of the BU (on the X axis).
Sales % A % B % C
...

**0**

votes

**1**answer

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

**5**

votes

**2**answers

17k 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 labels,...

**2**

votes

**1**answer

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

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

**2**

votes

**1**answer

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

**0**

votes

**0**answers

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

**3**

votes

**1**answer

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

**1**answer

4k views

### Grouping Excel charts in a Word document

I have some Excel charts that I've pasted into Word, and I would like to group them together so they move as a unit as I'm moving text around.
Currently, they look like this:
(forgive the rough ...

**2**

votes

**2**answers

397 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

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

**3**

votes

**1**answer

7k views

### possible to have two Y axes and two X axes on same chart

Is it possible to have a chart with
left Y axis
right Y axis
top X axis
bottom X axis
all on same chart?

**0**

votes

**1**answer

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

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

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

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

155 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 report,...

**7**

votes

**1**answer

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

**2**

votes

**2**answers

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

**0**

votes

**2**answers

403 views

### Why is my pivot chart not saving properly in Access 2010?

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. ...

**-1**

votes

**0**answers

106 views

### Get series values on condiation, excel [closed]

I have following data in my XLS -
8:35:01 NZLOAD app read: 2000005 01:03.0
8:35:03 Pending app INSERT 0 00:00.8
8:35:14 T4 app INSERT 1944132 00:09.6
8:35:47 NZLOAD app read: 2000005 00:...

**1**

vote

**0**answers

283 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

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

**1**

vote

**4**answers

62k views

### Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking.
My data might look like this:
London 23
London 22
London 44
London 18
...

**2**

votes

**2**answers

9k 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
02-Jan,...

**0**

votes

**0**answers

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

**4**

votes

**2**answers

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

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

**0**

votes

**1**answer

163 views

### Calculating Range coverage

I'm putting together a sheet that includes two data columns, 'Min Value' and 'Max Value'. All values between Min and Max values are consider the 'Range' of each entry. The goal of the sheet is to ...

**2**

votes

**1**answer

661 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

**2**answers

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

**2**

votes

**1**answer

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

146 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

684 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

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

**4**

votes

**1**answer

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

**2**

votes

**1**answer

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

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

**1**answer

18k views

### How to show an additional single point on a line graph in Excel?

I have a data set which shows the "efficient frontier" curve and a data point showing the decision made. I wish to have the data point be plotted in relation to the frontier but as an isolated point (...

**1**

vote

**2**answers

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