I want to set Category X axis lables range using vba
code (programmatically). and how to enable secondary Y
axis enabled and assign value to that secondary Y axis.
Please help me.

my chart has floating horizontal bars
they are price ranges that all have the same center point
i'm trying to draw a vertical line, starting from the x axis, going up thru
all the floating bars

 I create chart using VBA.
 I use chart type is XlLine. but it want show the second
value of Y axis. My requirement is show data and Axis
Title.

Can anyone tell me how to plot data on a US map using my Excel 2002 -- I thought I used to have a 'globe' button that would facilitate this -- do I need an add-in?  Thanks.

I have code that creates a graphic and text boxes automatically. But
when I try add drag the text box over the graphic its is masked by the
graph and does not go "on top of it". I don't understand why because
when I manually draw a text box and drag it over the graph it shows? I

I want to do a stacking column chart which compares two
values on the same column. Let's say Jan 03 in red and Jan
02 in blue. 03 value is 500, and 02 value is 800. I want
it to show red column up to 500, and then blue column up

hello
how do you create multi line axis labeling.
I have a bar graph with text angled at 45 degrees under each bar.
I would like to set the text so that it is displayed on 2 lines.

Ihaving problems trying to generate a secondary X-Axis.
The problem I trying to solve is:
I have data (Y-Axis)plotted as a function of Distance in
Miles (X-Axis). What I would like is to have a secondary X

Is there a way to rotate general text on a chart? There
does not appear to be a way to rotate a text box.
Thanks,
Paul

I chart many time series of data, usually annual, financial year,
monthly or quarterly.
Monthly data chart well with time series on the x axis. For example,
setting the major unit to 12 months and minor to 1 generates a neat x

EXCEL MACRO DEVELOPMENT
In order to provide clients with a quick analysis of the information
processed from our databases, we need to link the excel spreadsheet that is
a standard output of our software to a macro that will automatically chart

Hello --
Can someone suggest a source for code which  loops through all of a chart's
properties, and the properties of all of its elements?
Thanks for any help.

I wish to plot two Y variables against the same X as a  *scatter* plo
but would also like each Y scaled to its own Y axis (like the categor
plot with 2 Y axes).   There does not appear to be a standard o
advanced "built-in" chart type for this?  Am I missing something?  Ca

Assume 1000 pairs in 2 columns with values similiar to (12.2,17233).  x is in the range of 8.4-19.2 and y is 0-20000.  The x axis is on the bottom and the y is on the left with x crossing y @ maximum y
How does one plot this?

I can't get a horizontal line added to a pivot chart (column or line) by using the series method.  Can anyone help me out?  I'm trying to add the horizontal line to show things like the mean and standard deviation.
Thanks in advance.