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

**-1**

votes

**1**answer

39 views

### How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart:
I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...

**2**

votes

**1**answer

582 views

### Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this:
2014-02-20 23:04:57.9263690 +00:00
2014-02-20 23:05:02.3117944 +00:00
2014-02-20 23:05:02.7490564 ...

**1**

vote

**1**answer

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

votes

**1**answer

3k views

### How to combine multiple trendlines in a single chart?

I'm new in here and I love the forum already! I'm stuck with a problem now. I am doing financial ratio analysis of a company for five years and I need to show the ratios in a trendline. I have ...

**0**

votes

**1**answer

5k views

### How to plot negative numbers in Y-axis in Excel 2013

I have created a chart of Sales and Growth over a period of years... The growth is negative in a couple of years.
A normal combo chart with Sales in Primary Axis and Growth in Secondary axis looks ...

**2**

votes

**1**answer

469 views

### Create graph for requests per minute and uri

I have a table that looks like this.
time|uri
08:50:28|foo
08:51:42|bar
08:52:48|foo
08:53:49|bar
08:53:50|baz
08:54:02|bar
08:54:03|baz
08:55:27|foo
08:55:34|baz
08:56:47|bar
I would like to make ...

**3**

votes

**3**answers

2k views

### How to change Excel chart size with screen size

I have a Excel spreadsheet that is edited primarily from my desktop
computer at work (which has two large screens) but is also sometimes
edited on my personal laptop computer from home (which has one
...

**1**

vote

**1**answer

331 views

### Two problems with Excel graphing

See the following figure
I have two problems with Excel 2013, I am not sure how to solve these:
1) The axis title overlaps the data values on all my axes. From the figure, I am unable to change ...

**3**

votes

**2**answers

76 views

### X axis labels with “super-categories” or “headers”

How do I make the X axis labels of a column chart looks like this? i.e. with, for lack of a better name, "super-categories" or "headers", like the labels "All sites", "All sites excluding LR" etc. in ...

**1**

vote

**1**answer

3k views

### Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form:
X | Y
----+-----
3 | 42
4 | 57
6 | 92
11 | 119
19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 ...

**2**

votes

**1**answer

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

162 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

**2**answers

11k views

### In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart:
Looks ok, but the X-axis is ugly, so lets clean that ...

**2**

votes

**1**answer

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

**2**

votes

**1**answer

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

**3**

votes

**1**answer

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

219 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

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

820 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

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

**2**

votes

**1**answer

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

192 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

52 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

710 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

549 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

694 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

201 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

853 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

207 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

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

54 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

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

**3**

votes

**2**answers

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

**1**

vote

**1**answer

644 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

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

57 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

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

**2**

votes

**1**answer

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

**1**

vote

**1**answer

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

262 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

361 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

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

859 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

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

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

393 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

105 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

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

198 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

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