help with Excel Chart, Series name

  • Thread starter Thread starter Bilal
  • Start date Start date
B

Bilal

Hello,

I am using ORACLE OLE2 package to print a series bar graph in excel. I need
to rename "Series Name" that comes out in as a char in excel. By defual the
series are names as Series1, Series2, Series3,.....SeriesN. How can I access
the handle to "Series Name" which help me change its name. Any help will be
highly appreciated.

Thanks you,
Bilal
 
Bilal,

Manally, you do this with Chart - Source data - Series tab. There's a
series name box. Select the series to be edited in the drop-down at the
left first. It may have a cell reference currently in it, or you can
manually hard-code a name by typing it in, as a formula, as text. Something
like:

="My Series Name"

Using the macro recorder will yield the code for this.
 
Back
Top