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

learn more… | top users | synonyms (3)

0
votes
1answer
389 views

Excel area chart - y axis and major grid does not match 1 of the 2 series values

Using an area chart to show survey responses as two series with four data points in each. The x-axis are the four answer choices, the y axis is the percentage of respondents. The problem is the data ...
0
votes
0answers
1k views

How to get data series in Highchart from a JSON POST request (cross domain)

I'd like to create my own Highstock's chart on a local html file by using the JSON data series retrieved with a POST request to a third-party domain. I've read several docs on Highcharts' website but ...
0
votes
2answers
1k views

Excel Charts - How do i plot time on the Y axis

I am a keen runner and am trying to plot my progress on a chart using the following times 00:27:18 00:28:19 00:26:49 00:27:19 00:26:05 00:27:18 00:26:22 00:26:49 00:30:40 00:28:03 00:26:58 00:27:35 ...
1
vote
1answer
264 views

Cannot insert charts into PowerPoint 2013

I cannot insert charts into PowerPoint 2013. Each time I wish to, once I have selected the desired chart type and click 'OK', it simply blinks (exits and reopens). It then returns me to the same ...
-1
votes
1answer
1k views

How to create a 4 variables chart in excel? [closed]

I have been trying to figure out a way to create a chart with 4 variables in Excel. I can get to 3 with no problem but the 4th variable seems not possible. Here is my data (I am working with decoding ...
0
votes
2answers
152 views

How to make a 3D chart in excel

I found the same question but I'm not getting a 3D looking chart as posted in the answer. My data looks like this: 5 7 11 15 19 0.1 28 21 12 9 7 0.2 22 14 9 ...
0
votes
1answer
511 views

graph in excel to represent correlation of 3 parameters

I have some data in excel and I would like to make a graphical representation of those data. Structure of my data: persons ID : from 1 to 485 to every person, there is one parameter like average ...
0
votes
1answer
71 views

Excel Chart Timeline

I have a CSV file that I have opened in Excel 2011 for Mac. The CSV looked like this: Timestamp | URL 01/Jan/2014:01:01:01 /path/to/something1 01/Jan/2014:01:01:05 ...
1
vote
1answer
269 views

Display numbers twice on x axis in excel chart

I have following values that I would like to display on the X axis of my chart: 0,1,2,3,4,5,6,7,8,9,10,10,10,9,8,7,6,5,4,3,2,1,0 But my chart is displaying the values as ...
1
vote
0answers
109 views

How to chart time of day in Google Spreadsheet with midnight crossover?

I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after ...
1
vote
1answer
549 views

Set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

Is there a way to set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well? Basically I have a number of different stocks I'm ...
2
votes
0answers
232 views

Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows Mean values 61 43 Sample 1 0.009 0.059 Sample 2 0.108 0.099 Sample 3 0.043 0.038 ...
1
vote
2answers
5k views

Excel scatter plot with multiple series from 1 table

Say I have a table as follows: Label | X | Y | A | 1 | 1 | B | 2 | 2 | B | 3 | 2 | A | 4 | 3 | C | 5 | 4 | A | 4 | 3 | C | 2 | 1 | How ...
0
votes
0answers
21 views

Excel scatter plot with labels [duplicate]

I need to make an excel scatter plot. Col A = Names Col B = X axis Col C = Y Axis Doing a scatterplot on B,C makes the right chart. However, how do I add little labels to each point with the ...
1
vote
3answers
231 views

How to create a Horizon Graph in Excel?

Does anyone know how to create a Horizon Graph in Excel (preferably without needing to download an Add-In)? I believe these were originally called, "two-tone pseudo charts" developed by Saito and ...
1
vote
1answer
65 views

How to plot excel chart with multiple series from single data source

How do I plot the following multiple series information on a single chart: DateTime SeriesName Duration 2014-05-02_10:21:21 X 2013.006 2014-05-02_10:21:22 Y ...
1
vote
2answers
2k views

How to get charts to automatically update with new data added?

If I were to have data in excel just like the table below, and then make line charts with that data. All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data. ...
1
vote
2answers
65 views

Excel plot digitizer [closed]

Is there any plot digitizer usable in Excel? I have discrete points (values X and Y) and I have to create graph from these - Excel can create the "mean curve" (I am sorry, I am not a native speaker so ...
0
votes
2answers
213 views

Superscripts in Excel chart labels

I have data like this in two columns: 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 ...
0
votes
1answer
2k 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
2answers
79 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
1answer
604 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
262 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
1answer
468 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
2answers
548 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
1answer
84 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
389 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
53 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
76 views

Automatic scatter plot in Excel 2010 [closed]

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
53 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
201 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
543 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
2answers
125 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
1answer
146 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
1answer
900 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 ...
2
votes
0answers
51 views

How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
0
votes
1answer
63 views

Excel scatter chart to show crossbar on selected point

Is there a way to configure Excel 2010 to show a crossbar on selected point in a scatter chart? The default behavior is to show a tooltip with the point's value when hover over the mouse cursor. When ...
1
vote
1answer
86 views

Excel Scatter Diagram

I have data in Excel as follows (just example of them, not all): Name | Asset | Count ----------------------------- John | Apple | 1 Adam | Banana | 2 Pete | Apple | 1 Mark | Berry ...
-1
votes
1answer
38 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
319 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
507 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
0answers
81 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
1answer
2k 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
1answer
3k 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
1answer
298 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
3answers
1k 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
1answer
151 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
67 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
2k 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
1answer
11k 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 ...