Sorry if this is doubled we lost power when I hit send and I don't see it
I have a pivot chart where the x axis has dates.  It currently is displayed
as 7/31/08 and I need it to be Jul-08.  I have gone into the format area
chosen number then date and chosen the Jul-08 format but ...

I have a two data series to place on a chart (chart type = stacked column).  
I would like to have the y-axis show the numbers and the data labels show the
percentage of total for that particular data point.
For instance:

Excel has SetSourceData, which I love because it is so elegant.
Unfortunately, there was no yin to the yang: No such thing as
GetSourceData was made to accompany it.
I needed this long ago, but ended up writing some ridiculous

When I add callouts to a chart, some of them stay in place and some disappear
when I click away from the chart.  I have tried to bring them forward and
send the chart to the back but still the same results.  Any help?

Hi quick question,  was wondering what the custom format is to display the
percentage number without the percentage sign. eg.
to change 400% into 400 without changing the source data.
If i change it from a percentage format to number format it changes from

Hello. I am Using Excel 2002 create a bar graph, which is linked to a
word file (Paste Special>Linked Microsoft Excel Object, left at 100%
scale), which is subsequently printed as postscript file, which is
rendered into a pdf by Acrobat Distiller. The word and excel files are

I am trying to take my std dev, mean, z, p, Confidence level, etc...plot and
shade areas using excel.

I understand that you change the actual text that appears in the legend, not
the font of it. I tried to follow the example given on this site and doesn't
work.
Here is the formula for one of the markers in the Chart. The formula refers

I have a number of pivot charts that displays the same kind of data (hours
registered on different projects). I want to use the same color for the same
project in the different charts, but when I change the order of the projects,
Excel changes the color automatically. Is there a ...

Is it possible to do the following:
Stacked bar chart for 3 data series.
Regular bar chart for 1 data series.
Line chart for 1 data series.

I am trying to do something that seems like it should be simple with a custom
graph, but in trying to build my own custom graph am not seeing how to really
do any customizing.
I want to make a 2-axis chart, but instead of 1/2 the series being bars and

I believe there is a flaw with the boarders on 3-D pie charts in Excel 2007.  
Try to enter some data - say 6 names with unequal percentages that sum to
100%.  If you chart this data using a 3-D pie chart and give the pie itself
and the pieces of pie black boarders the boarders ...

Once we know all the elements we need to put together a chart, is
there way to automate the end result somehow?  I have a complex set of
charts that I'll need to create monthly, then quarterly and then
yearly.  I'm going to have a hard time remembering all the elements to

Using Excel 2002
I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw data.
The data resides on their respective tabs. I want to use the same chart and
format for each tab. I copied the chart from Sheet1 and pasted it to Sheet2.

How do you create transparent areas in imbedded charts? (for Excel 2003).
When I click on "Format Chart area", then "Fill effects", there is a place
where you can change the transparency settings, but it is faded out and will
not work. Any Ideas?