If I have a series over time with data for only some points e.g.
Q1 2 - 1
Q2 2 - 3
Q3 2 - 5

How can I keep the properties in a pivot chart, like the
color of the graphic, after I choose other option on the
chart?

how to hide zero and empty values in a chart (x-y-plot), and how t
program it in vba.
Sigg
--

I have 25 charts based on dynamic ranges and featuring links to other
workbooks.
My question is actually twofold:-
1.     The charts all update themselves fine.  I have about four

I am creating simple horizontal bar graphs using data such
as:
apples     10.9%
oranges    11.1%

I have a dynamic bar chart for which I want negative
values to be red and positive green. Because it's dynamic,
I can't simply take each bar and change it to red or
green - next time around the values are different.

Has anyone experienced this problem. I am reducing the height of a chart PlotArea.
The following code has no effect on the .Height property of the PlotArea!
With ActiveChart
      With .PlotArea

All -
Pretty basic question.  I have a pivot table (chart) that is charting
set of issue into four priorities (P1, P2, P3, P4) over time.  We ar
looking for how many of each priority issue we get each week.  Prett

Is it possible to plot a series from code. What I want to do is plot some horizontal lines that do not change
For example I the y values will be say 50 for any given y value
Another way to think of this is I want to add horizontal gridlines at pre-determined points
Any ideas on how ...

I have a series of data that is always being added.  We
have an Name, X, Y value how do I continue to have it
placed on the chart without having to do it manually.

I'm using Tushar Mehta's dynamic chart method for
plotting a normal curve, and the scale minimum for the X-
axis (set in "auto" mode) seems to want to be zero, even
if the curve is no where near it (even when the mean is

I have three columns on my data spreadsheet;
some columns have info, while others do not
and are blank.
I am trying to make a Pivot Table that

I'm trying to do a pie chart that show both the value and
the percentage but have had no luck.  Does anyone have a
trick on how to get both to show up at the same time?  
Thanks.  Kathy

I would like to display market share info (%) and contribution margin info ($) in excel. Any help would be appreciated. Thanks

I have data for several chapters which i would like to create charts for.  However, one chart at a time is to cumbersome.  How can I create multiple charts for the different chapters and personalize them at the same time?