I create a series of Pie charts each month which will
inevitably have some zero values. Each time I have to
update the labels via Chart Options and then delete the
zero ones.

I would like to create multiple charts for different chapters at the same time.  Is there a way to do that in Excel.  I would also like to preset my preferences, so that i do not need to tweak each one.  The data is all compiled within on worksheet, but the data is for several ...

I would like to plot data on a graph using log scale on
the y axis verus a standard division on the x axis. How
can I do this or where can I find info on ding it?
\

I supervise about 40 employees who seem to have a high absenteeism rate.  I need to be able to graph/chart the absenteeism for individual employees in order to identify any potential TRENDS.  The absenteeism is not as important as being able to recognize trends.  Example:  (1) ...

I'm having trouble with some charts I am making in Excel 2000.
What I want is to be able to plot 3 repeat X axes one after the other
but I cant work out how to do it. My data has 0 to 600 seconds along
the X which I would like to repeat a further twice in a row along the

I want to plot line graphs with seven series of numbers using the left vertical axis (x) and one series using the right vertical axis. The horizontal axis (y) is coomon to both, (date). I'm using the chart wizard to set up the graphs, however when I do the graphing some of the ...

I am trying to see my data as "% of parent row" in excel pivot tabl
but this is not possible. I can select show data as "% of column" bu
this percentage is calculated based on the total of all data in column
I just want to see the percentage for that parent row. In Access thi

Dear Sir,
I'm an Excel user and have a problem with drawing a
special chart.
The question and its chart are as follow:

I am trying to plot values vs. numbers but the numbers don't increase in a linear or predictable patern so excel is filling in the numbers inbetween automatically. For example I want to plot values vs. 1, 2, 3, 4, 6, 8. 9, 11 and 15 and so on but instead of excel plotting my ...

I noticed I was not getting any replies from you gurus. I
attached the file this time so you can maybe see what I am
talking about. I know this can be done, my question is
how? I'm sure I need to set my data up differently, maybe

I have some spreadsheets with dynamic charts - ie as data is added to
the worksheet, the chart automatically updates.
The charts are line graphs - date on the x axis, data on the y axis.
The dynamic formulas I use for the x axis (readdate) is

How do you include a Microsoft Excel chart in a mail
merge? There will be a different chart for each row of
data, which I want to place in each Word document during
the merge.

Trying to allow a scatter graph to have both axes flex to
a cell reference.  Below is my non-working code.  
Help?!  TIA!
Option Explicit

Does anyone know if there is a way to hide all the Pivot
Chart field buttons on a Pivotchart but still display the
page field drop down?  when i hide the field buttons they
all go away, including the page field that i would like to

I am looking for a way to include a delta between my primaray an
secondary axis at each interval on a graph and I'm not sure if
function already exists within excel to support that.  If anybody ha
any suggestions, I would greatly appreciate them.