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

**0**

votes

**2**answers

40 views

### Superscripts in Excel chart labels

I have data like this:
2 | 5
4 | 6
8 | 7
I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...

**0**

votes

**1**answer

19 views

### Excel chart with a single x-axis but two different ranges (combining horizontal clustered bar and horizontal stacked bar), possible?

I am new here. I have a data set of density values (phytoplankton community) according to depth and the composition of it in percentage. I want to ask if it is possible to construct the density values ...

**1**

vote

**2**answers

37 views

### How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like:
5/29/2011
6/21/2011
6/26/2011
7/1/2011
7/3/2011
...

**1**

vote

**1**answer

14 views

### Changing the units on the x-axis in a LibreOffice Calc chart

I've used the LibreOffice chart wizard to make a chart, and I would like the x-values to be different to the default of 1,2,3... (in this case, 500,1000,...). How can I do this?

**0**

votes

**1**answer

30 views

### How do I group and chart date ranges in Excel?

I want to visualize the use of vehicles in a family through time. I have collected the dates each vehicle was being used as follows (example data) :
And want to somehow chart the data to visualize ...

**0**

votes

**1**answer

27 views

### What are the labels for minor ticks in a log scale graph?

What are the labels for the minor ticks in a log scale graph?
I would like to label them. So, I want to know how to calculate the value for each of the minor tick.

**1**

vote

**1**answer

57 views

### In Visio, how do I create a chart with coordinates throughtout time

I have these data (from MSSQL, that I converted into Access/Excel) on a moving object in a defined space
x y time
0 0 07/04/2014 08:48:07
5 5 07/04/2014 16:35:25
6 4 ...

**0**

votes

**1**answer

18 views

### Excel - Quickly Charting Frequency of Event To IP Address Over Time

Warning: Keywords and tricky phrases may not be correctly being used here. I'm not extremely knowlegable about the terms used with Microsoft Excel so I'm using my best guess.
I'm failing to find a ...

**1**

vote

**1**answer

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

**3**

votes

**2**answers

29 views

### Automatically updating bar chart?

So for a project at work I have a table in excel that contains numbers for each month of the year up to this one in four categories. It looks (a bit) like this:
...

**2**

votes

**0**answers

43 views

### Automatic scatter plot in Excel 2010

I have two quite large data sets of which I want to plot every line in one plot.
The pattern is the following:
x-axis: Set one (Colonne 1-6)
y-axis: Set two (Colonne 1-6)
Now I want such a plot for ...

**1**

vote

**1**answer

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

votes

**1**answer

24 views

### How to create line chart in Excel with two series of ordinal/nominal data?

I have these two columns in Excel.
Result Speed
------ ----
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
HIGH HIGH
MEDIUM HIGH
HIGH HIGH
HIGH HIGH
HIGH ...

**2**

votes

**1**answer

39 views

### How to make Excel chart axis start NOT at major unit?

Is it possible to have an Excel chart where the axis does NOT start at the major unit?
See the example below, where I want the x-axis to start at the year 2007, but have major unit 5 years and show ...

**1**

vote

**2**answers

36 views

### How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises.
Here is the data:
...

**3**

votes

**1**answer

90 views

### How can I have automatically updating copies of charts?

I have been doing some more complex work with Excel (different tabs/worksheets, etc.).
Now I have some charts from one worksheet that I'd like to kind of embed in the other worksheets for the purpose ...

**0**

votes

**1**answer

18 views

### Excel Chart from Multiple Sheets

I have a bunch of sheets and each one has a value in cell K15 and call K20. How do I make a stacked column chart that shows these values stacked for each sheet?
Forgive my crude drawing, but ...

**0**

votes

**0**answers

10 views

### Magnifier doesn't follow focused element in google chrome

I am writing a website that shows a chart for user.
When user changes selected point of chart with keyboard right and left keys the point is focused (I am talking about actual javascript focus).
...

**-1**

votes

**1**answer

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

**0**

votes

**1**answer

33 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

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

**0**

votes

**0**answers

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

**-1**

votes

**1**answer

77 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

228 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

50 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

**2**answers

155 views

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

I have posted the following question on StackOverflow, but was told that it would be more appropriate here instead. Any assistance that could be provided would be much appreciated.
I have a Excel ...

**1**

vote

**1**answer

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

**2**

votes

**2**answers

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

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**0**answers

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

**1**

vote

**1**answer

54 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

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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

53 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

183 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

451 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

73 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

72 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

44 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

168 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

201 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

85 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

70 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

162 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

47 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

244 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

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