It occurred to me that it would sometimes be useful, when using a
Excel scatter plot with more points than the horizontal resolution of
my screen, to be able to click on the chart and get a plot of the
last, say 100, points. It may seem lazy but I can't think how to

How is the "Pie of Pie" chart used?  I know this is the
chart I need, I just don't know how to plot the data.
I have 3 discrepancies - Broken 85%, Misplaced 10% and
Incomplete 5%.  I want to create a pie chart that shows

How to customize y axis to display small number in
thousandths unit. For example, 0.0045 will be displayed
as 4.5.  I don't want to use scientific notation E,
instead putting "thousandth" in y-axis label.

I am trying to make a chart a pop up or a link, I am needing to do multiple
charts on the same worksheet for each row, and this is the only way, I
believe the charts would be readable.  
Also is there a way to copy the same date ranges for each row(similar to

I'm having problems on how to automatically add a text box to
chart...containing the text of a cell from an other sheet.
Even when I put the textbox allready on the chart, I cannot put th
text from say sheet1 cell A1 in that textbox.

I'm probably not the only one having this problem: How can I get the
same plotarea size for all charts on a sheet?
The plotarea can not be set from Excel nor from VBA, only the chartarea
as far as know.

I am trying to create a scatter graph which allows me to show the evolution
of several teams on a scatter plot.
I have two data per team (rank and goals). Rank must be the Y axis and goals
the X axis. That should be perfect for a scatter, but I want to show the

Going mad - don't know if it is a general Excel chart problem o
specific to Macs (or my MAC?)
Various charts I have put together seem to change format at will
usually when I save the file or print it. Changes are usuall

When I try to format the data label position on my chart, the optio
"outside end" is missing.  Anyway to get it back
--
bernchi

I have a line of text on a chart that gives the N that
the averages were calculated with for the chart.  It
looks like this:
               Title Text (Placed by the wizard)

Thanks, Tushar, for your response.
The problem is that the chart is referring not to the parent workshee
but to another worksheet in the same workbook.  When I copy all th
sheets over at once, it still keeps its reference back to the origina

I notice that when I put a date and drag the little square in the bottom
right of the cell to adjacent cells, the other cells will have a date
increment by one day.  However, how do I do this when the cell is not
adjacent and far apart?

I'm trying to create a filled radar graph with transparent layers. If
fill the base layer with a color then the gridlines dissapear. Whe
trying to make subsequent layers transparent the transparency slide i
greayed out. Is there a remedy to this? Through VBA?

I made a waterfall chart but I cannot attach "BOTH" values
and lables on it.  It only allow me to chosee 1 of them at
at time.
How do i do this without using any add-ins.

How does one get long text boxes created in a chart to
print preview and/or print as seen on the screen?  When a
long text box is created in a chart, you can set-it-up so
that it is lined-up exactly as wanted relative to the