dear community:
Everytime I update the chart data range, I have to Select i
first:
ActiveSheet.ChartObjects("Chart 1").Select

After I updated to Exel 2002 the pictures I had displayed
on a chart wall does not print properly...
It looks fine on print preview but when you actually print
it only show's a small portion of the picture...

When I paste an excel chart into a powerpoint slide
(pasting as links), the powerpoint pasted chart has
changed totally.  Line breaks on the Y axis's have
changed. Any ideas on this!

Is there any way I can have subscript/superscripts in the legend of a chart?  If it's not readily available, can a VBA script take care of it?

I cannot seem to get this to work but I want to create
either a bar of pie or a pie of pie.
I have 3 data poits adding to 100% (easy Pie chart) Say
Fruit(50%), Veggies(25%) and Grains (25%).  I want to

Dear Reader
Thank you for your attention. In my Macro in Excel, I had
the following statement to make the column chart filled with Sample.jp
with scale 500:1

I want to show the means, 25th percentiles and 75th
percentiles on a chart for a series of data. Anyone know
how to do it.
Thanks

Suddenly this week I am getting some message in this and other
msnews.Microsoft.com Excel newsgroups that are clearly answers (the subject
begins Re) but there are no corresponding questions. There are some paired
questions and answers but clearly some questions have gone missing.

Does anyone know how to apply an alternate data label to a
series other than the series name, value or category.
Ultimately I want to take a bar graph of a treatment-
response per compound and add a label per bar based on the

I need to show a data table on the Excel Chart  with YTD total but not have it graphed as it would skew the scale of the graph
Is there a way to have one data point to be part of the data table but not to be graphed
Alex

I have created a pivot chart (stacked column) in which I
also use a secondary axis represented as a line.  My
problem is this.  Whenever I change my data or criteria
(via the pivot table drop downs)my secondary axis

Does anyone have some code I could use as a starting point to select
an embedded MSGRAPH object (this type: EMBED("MSGraph.Chart.8",""))
and update the values on the charts datasheet with values from another
source?  In this case I'll be updating with values from other Excel

Hi, you'll like this one.  I've overlaid an X-Y scatter
chart with another that contains different source data.  I
formatted the background of the "top" chart so that when I
click back onto the spreadsheet, I can see both plots. The

OK, can you people tell a thick twit how to automatically extend a chart
range by rows as I type in more data each day?
Thanks

I am trying to create a bar graph in excel 2000. I am new
with this so please bear with me.
What I have is 3 columns:
Column a Department (text)