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

learn more… | top users | synonyms (1)

0
votes
1answer
2k views

Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...
0
votes
1answer
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
1answer
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 ...
2
votes
3answers
9k views

Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...
0
votes
2answers
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/ ...
1
vote
2answers
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 ...
0
votes
1answer
21 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
1answer
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
1answer
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 ...
1
vote
1answer
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 ...
4
votes
3answers
18k views

Excel: making line charts so the line goes through all data points

I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around? I've ...
0
votes
1answer
3k views

Excel scatter chart, with grouped text values on the X axis

Apples 1 Apples 5 Apples 2 Bananas 1 Bananas 4 Bananas 6 I want two bars on the X axis (Apples, Bananas), but with crosses marking the points on the Y axis. Here's a mockup: I'd want 1 ...
0
votes
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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 ...
0
votes
1answer
2k views

Adding 80% horizontal goal line to pivot chart

I have a curve pivot chart to which I'd like to add a goal line with a static 80% horizontal line. I've seen some people suggest that one could merely add a column with 60% to the dataset. My dataset ...
-1
votes
1answer
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
1answer
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 ...
10
votes
2answers
49k views

Excel chart with two X-axes (horizontal), possible?

Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ? I want to use the second axis to plot the normalized value of the default horizontal axis. ...
1
vote
2answers
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: ...
0
votes
7answers
12k views

Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following: The x-axis has the wrong scale - it should range from about $3000 to ...
2
votes
3answers
1k views

Is it possible to have a custom data table visible underneath a chart in MS Excel?

I have a column chart with a single series of data to be shown on the chart. However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...
3
votes
1answer
91 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 ...
9
votes
1answer
213 views

How to turn a 3D chart into something watchable on a 3D television?

Let's say I have a 3D scatter plot in R or a data frame with 3 fields filled with numeric data. How can that be "turned" into "something" watchable on a 3D television (like a random big screen TV ...
0
votes
1answer
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 ...
1
vote
5answers
552 views

Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact) code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5 Every day I ...
0
votes
0answers
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
1answer
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
1answer
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
1answer
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 ...
-1
votes
1answer
79 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
0answers
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 ...
0
votes
1answer
230 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 ...
3
votes
2answers
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 ...
2
votes
1answer
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 ...
2
votes
1answer
2k 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
1answer
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
2answers
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
1answer
127 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 ...
0
votes
0answers
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
1answer
216 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
1answer
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
2answers
664 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
1answer
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
2answers
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
1answer
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
3answers
6k views

Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart? I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...
0
votes
1answer
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 ...