I am using XL 2003 SP1. I created a stacked column chart that is located on
the same page as the data. When I click off of the chart, it is completely
shaded, you cannot see any of the chart detail.  When I select the chart you
can see the entire chart as you normally would.  I ...

I am trying to create a floating chart that clusters various asse
classes together by time period, i.e. I want a stock and bond floatin
chart for 1 year, 5 year etc.  I can do the floating bar chart, but
cannot get my charts to cluster together.

I often want to look at XY plots of various combinations of data. What
would like to be able to do is simplify (and speed up) the process b
being able to select the x and y series using dropdown lists.
ie: I import the data (varying rows and columns) into a sheet and the

I want to create an XY grapth with multiple axes. please help.

Is anyone aware of tools such as ASAP utilities that can be used to
draw charts in excel?
You can write me on kaustubh.naik@gmail.com
And if you havent tried ASAP utilities.  Its fun.

Does anybody know the formula that excel uses to create chart axis
parameters?  I need to know how it defines the major unit and the maximum.  
Any Ideas?
Thanks in advance

Hi,
I have a number (approx. 30)of sales charts that each month need to change
the series for, so that the charts will include the new months sales.
Is there anyway other than to go into each individual graph, and change the

I am working on a line chart and I need to specify a specific range for the y
axis, but was wondering if it possible to plot the one outlier datapoint
outside of the excel chart?

I'm trying to create a line chart with the x (category) axis showin
time.
If I open Chart Options and select Automatic for the x axis, the date
start at 01 January 1900, ignoring my date data.

I have mutiple-series charts, but would like restric the drop lines only to
only one (ususlly the first) plotted data series.  However, the drop line
option seems to apply to ALL data series and creates an unreadable mess.
Is there a way to see only what I want, i.e. the drop ...

I have 5 sets of data, each with a before and after amount that has been
charted using a simple bar chart. Is it possible to have excel, using a line
from the before element to the after element, show the % change between the
two?

Can I combined stacked columns & clustered columns in a single chart?

This is in Excel 2003.
I have a block of numbers in  C104:I111, with columni labels in C103:I111
and row labels in B104:B111.
I want to create a line chart with the rows as series and column labels as

A workmate with the same version of Excel has a different set of data markers
available. I found the article below that says alternate patterns and styles
are available - but didn't say where - can anyone help?
This article was previously published under Q97589

Is it possible to draw a number of equally spaced circles (say 5) around a
point in a chart??
I mean that my chart will look like this when I run the VBA procedure.
http://phpaw.com/myscrpit/milt-up/jpg/jpg-1125313279.jpg