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
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
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
41 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
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 ...
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
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
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
102 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
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
1answer
76 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 ...
2
votes
1answer
49 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 ...
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
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
1answer
207 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
626 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
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
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 ...
1
vote
1answer
182 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
0answers
43 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
2answers
166 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
200 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 ...
0
votes
1answer
69 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
1answer
46 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
0answers
134 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 ...
1
vote
2answers
1k 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 ...
0
votes
1answer
716 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
1answer
240 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 ...
2
votes
2answers
138 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
2answers
105 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 ...
0
votes
1answer
270 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
1answer
870 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
1answer
170 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
1answer
38 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
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 ...
2
votes
2answers
254 views

Excel Scatter Chart with category based formatting of points

I have some data which I would like to plot in the scatter chart in the following format date, category, value 01-Jan,Cat1,0.03 01-Jan,Cat2,0.13 01-Jan,Cat3,0.27 01-Jan,Cat4,0.32 ...
0
votes
0answers
215 views

Excel VBA updating graph data

I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...
3
votes
2answers
324 views

How to make a chart that graphs frequency of entries?

I have an Excel workbook that has nothing but dates (sorted), in the following manner: 11/14/2011 11:53 10/14/2012 11:53 11/23/2012 19:28 12/24/2012 12:27 ... 12/1/2013 11:48 I would like to create ...
0
votes
2answers
55 views

Embed Excel Charts into Powerpoint Issue

I am currently experiencing an issue with powerpoint 2010. I have created a three part chart in Excel and am trying to export it to powerpoint. However whenever I try to paste special the excel as an ...
0
votes
0answers
123 views

How can I create a matrix chart with Excel 2010?

I want to create a chart where, if the value of a cell matches the criteria of both its row and column, I can mark it with a cross. I could just type an 'x' into the cell, but I would like to find ...
2
votes
1answer
165 views

Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.
0
votes
1answer
410 views

How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis. For example, I imagine the questions ...
1
vote
1answer
129 views

Create a excel chart only with axis

I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100 Is this possible? If so how to do it? ...