I try to create some Excel-diagams by VB-code.
Six diagrams are ok. But in the 7th - the last - diagram, I cannot set
the plotarea.height. The chart.height is 80 but the plotarea only 41. I
just recorded my right settings with the macro-recorder and set the

Hi, I'm trying to plot a chart with more than 800 series. The problem
is that I want all the series to have the same format(color, weight
and line type). I have to do about 5 of these, so changing each series
to the same format can be really cumbersome. Is there a way to select

I am trying to plot a data set with a conditional.  Here are a few of my
attempts :
=IF(O111=0, NA(),IF(O111<6,O111,NA()))
or

How do I replace the data point markers (diamond, star etc.) with
text which is unique for each data point?
Example .. Lets say we have this dataset:
Name: Alfa Beta Gamma

I would like to create a 3 dimensional chart, based on a stacked bar chart.  Specifically, I would like to give the individual elements of each stack different heights, in a 3rd dimension.
Forinstance:
Category A  Element 1, Width 75, Height 10;
Category A  Element 2, Width 25, ...

I have 2 charts on a sheet, each representing different data, one on top of
the other. I would like the plot areas to line up with each other. I can do
this easily with no data, but when data is added, one will be bigger or
smaller than the other. There is new data added every month ...

I have an area chart with two Y-axes.  I'd like Excel to
keep the scale for the two axes the same - anyone know how?
Note: I have a data series which I want to appear as a
dashed line - not part of the area chart.  That's why I've

I have a template workbook with a two sets of data and two
charts on the same worksheet.
I scan through another set of data (sales data) populating
the data on the chart worksheet for each row of sales data

On different worksheets are (Forms) Buttons with the below
macros assigned to them.  "GoToUtilizationChart()" works
perfectly, but "GoToPPVChart()" only brings up
the "Metrics" worksheet and cursors to A1 - it does not

In Module3 of a workbook (solely dedicated to
LastPointLabel) I have downloaded/copied the following
code from your geocities website:
 Option Explicit

Jon,
I have successfully run the LastPointLabel macro.  Three
line series have been properly labeled.  Two series are
simply straight lines across the chart, and the third

Excel 2002 I would like to know if it's possible to
display the results of a year's 4 quarters in one pie
chart and then break one of the four monthly totals in
the little chart. No matter what I do, it seems to total

When I use the pivot chart how can I display the grand totals (which are calculated by the table) as a series?  I'm talking about the row and column totals that are calculated when you have the correct box selected in pivot table options.

I want to create a bar / column graph using Microsoft
Graph where each data entry consists of a range of values
(i.e. has a lower and upper value).
For example: I have 3 different products.  The price of

My users are not excel-savvy enough to be trusted with
chart formatting controls, so what I'd like them to be
able to do is set the minimum and maximum axis values for
a chart in fields, that can be referenced by the chart. Is