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

learn more… | top users | synonyms (3)

5
votes
3answers
7k views

How to fill in missing dates in chart

I'm looking for a simple way to chart a list of values each correlating to a date. For example: Date Value 11/7/13 2 11/8/13 2 11/11/13 3 11/14/13 2 Etc. The problem is, the chart does ...
0
votes
2answers
79 views

Finding trends in multi-category data in Excel

I have an Excel spreadsheet that contains hundreds of rows of data that each represent a single sample in a larger population. Each row is divided into three columns that contain frequency counts of ...
3
votes
1answer
369 views

How to antialias trendline in Excel?

I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly: I have tried ...
-1
votes
1answer
243 views

Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV. How is it possible to ...
0
votes
1answer
4k views

Adding text axis labels to excel scatter chart

I have a Spreadsheet with data like this Label Data PA_1 1 PA_2 2 PB_1 3 with hundreds of rows. I want to create a scatter graph where the x-axis contains the names in the label column. ...
5
votes
2answers
2k views

Linked images in PowerPoint not updating

First of all, excuse me if this question is asked on the wrong StackExchange site. I have a PowerPoint (2010) presentation with two slides. Both slides contain an image (two different images), and ...
2
votes
1answer
8k views

Advanced Chart in Excel - column width based on cell value

I am an intermediate excel user struggling to create a specific chart for an internship project. I have spent a lot of time trying to figure it out and have searched the web extensively. Below is an ...
10
votes
2answers
480 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
1k 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
476 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
1k 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
200 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
797 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 ...
4
votes
0answers
395 views

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

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 ...
2
votes
0answers
1k 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
673 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
2k 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
246 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
1k 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
82 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
111 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
455 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
3k 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 ...
13
votes
2answers
138k 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
249 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
3answers
11k 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 ...
0
votes
1answer
4k 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
647 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 ...
-1
votes
1answer
46 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
1answer
1k 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
1k 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
5k 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
9k 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 ...
1
vote
1answer
839 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 ...
1
vote
1answer
6k 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 ...
4
votes
1answer
17k 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 ...
0
votes
1answer
332 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 ...
6
votes
4answers
1k 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?
1
vote
1answer
2k 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 ...
0
votes
1answer
6k 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
0answers
261 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
0answers
54 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, ...
1
vote
1answer
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
1answer
379 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
1answer
270 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
4answers
8k views

My pivot chart has the wrong Y axis values but correct data point values

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values. The values on resulting lines are correct (see the data label at the end of the line) ...
1
vote
1answer
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?
2
votes
1answer
59 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 ...
2
votes
2answers
341 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 ...