0
votes
1answer
15 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 ...
0
votes
1answer
17 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
29 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 ...
2
votes
0answers
39 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 ...
3
votes
1answer
87 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 ...
1
vote
1answer
91 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 ...
3
votes
2answers
142 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
2answers
39 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
114 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
190 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
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
90 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
52 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
1answer
173 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
70 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
2answers
160 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
194 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
1answer
77 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
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 ...
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 ...
1
vote
1answer
98 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?
1
vote
2answers
102 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 ...
2
votes
1answer
837 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 ...
2
votes
0answers
49 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...
3
votes
2answers
319 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
0answers
35 views

How to use a variable end column in a SERIES (chart) forumula in Excel 2010

One of the series in my chart looks like this: =SERIES('sheet1'!$A$13,'File.xlsx'!Xaxis,'sheet1'!$B$13:$S$13,3) So what I understand is: The first argument is the series name The second argument is ...
0
votes
0answers
121 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 ...
1
vote
1answer
125 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? ...
2
votes
1answer
5k views

Excel generate and format horizontal error bars

I have been trying to generate and format horizontal and vertical error bars in Excel 2010, and there is no problem with the vertical ones, but I cannot figure out how to manage horizontal error bars. ...
0
votes
1answer
728 views

ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that? Sub DeleteGraph() Dim graph As ...
1
vote
2answers
1k views

Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0. I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10: 30, 20, 10, 0, -10, -20, -30 I have set set ...
1
vote
2answers
351 views

Changing the axis labelling in a Excel 2010 scatter plot

I am trying to represent a list of data points in such a way that the graph starts at X coordinate '1' but that labelling starts at coordinate '100' and I have been unable to find out how to do it as ...
5
votes
2answers
2k views

How can I stop Excel from rapidly refreshing/flickering while data is being loaded from external sources?

I have an Excel spreadsheet with several charts on the same worksheet. Each chart's data comes from a different table. Each table's data is pulled from an Access database, and the connections for each ...
3
votes
1answer
1k views

Multiple bar charts on one axis in excel

So I have a bunch of series laid out like this in excel: I'd like to have them plotted all on one column chart but with the series separated (i.e. not clustered) so it basically is several column ...
4
votes
2answers
3k views

Multiple Y-axis labels in Excel 2010 line chart

I have a table containing cycling data. Date, distance, time, calories burned, max heart rate and average heart rate. They all have different value ranges. Excel scales the chart to show the calories ...
1
vote
1answer
1k views

conditional chart ranges in excel

I have a table of data in Excel 2010 that looks something like this (but with hundreds of thousands of rows over multiple days): I am trying to create a dynamic chart where the x-axis is the ...
0
votes
1answer
615 views

Optimally positioning pie chart data labels in Excel with VBA

I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size. I want to display the data labels ...
0
votes
1answer
58 views

Custom Chart Axis

I have an Excel chart whose X-axis values are 5000, 10000, 15000 and so-on but I want them to be like 1,2,3,... i.e. divide them by 5000. Is there any way I can accomplish this?
3
votes
1answer
256 views

1/3 octave band chart in Excel?

I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this ...
1
vote
1answer
287 views

pivotslicer connected to multiple pivotcharts

Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes: Department --> Section If I choose "Section A" Then I can ...
0
votes
1answer
162 views

Excel PivotChart count rows where not blank

I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was ...
0
votes
1answer
99 views

Excel 2010 charts from ungrouped data

I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such Falun Borlänge Stockholm Uppsala Borlänge Stockholm ...
0
votes
1answer
375 views

How can I increase Excel's graph axis area?

This is what the x-axis of my graph currently looks like (Excel 2010): The dates are in the format YYYY-MM-DD, but as you can see month and date are chopped off. I tried resizing (the dots at the ...
2
votes
2answers
12k views

XYZ 3D-chart in Excel

I have a table of data as follows: X Y Z N1 2 5 6 N2 2 7 8 N3 0 1 2 N4 0 4 5 N5 9 10 10 N6 4 9 9 N7 0 2 4 N8 0 7 8 N9 0 7 8 Now I would like to ...
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
vote
1answer
242 views

Label's format in barchart different from the corresponding cell

I have stacked bar chart. In the label's format I checked "linked to source". Now in the datacell,l I have this custom format "[>999999]#.##0,00.." M$";[>999]#.##0,00." k$";#0,00$". The problem is ...
0
votes
1answer
36 views

Blank Excel PivotChart

My Pivot Table has everything I want however,I want my chart to show how many Issues have the status of severe, mild, or moderate. But instead it is blank. What should I do?
0
votes
1answer
112 views

How do I select a blocked chart in a Excel 2010 chart?

How can I select a blocked or protected chart in Excel 2010? When I right-click on the chart, the cursor changes to a circle with a diagonal line within it - a "blocked" sign. I'm doing a study ...
0
votes
1answer
277 views

Making chart from custom data format in Excel 2010

I am defining custom data format via Apache POI. I know I need to use following construction: DataFormat data = this.workbook.createDataFormat(); ...
3
votes
1answer
9k views

How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?

Let us consider a following data set: Name | Age | Hair Color ----------------------------- John | Young | Brown Sophie | Old | Blond Adam | Mature| Blond Mark | Teen | Dark Jeremy | ...