Prev: Search Directories/SubDirectories and Display in ListBox or Ms
Next: XML and SharePoint
From: Stratuser on 1 Apr 2010 13:21
In VBA, how do I specify the worksheet range that I want the chart legend to
come from? My legend data is separated from my values data by several rows
in the worksheet.
From: Peter T on 1 Apr 2010 13:35
The legend-entries are defined by the series. They show the same format as
the series and the series name. Apart from deleting individual entries or
not showing it at all, there is nothing you can do to change the entries,
except of course by changing the series data (which you can do with VBA).

Regards,
Peter T


"Stratuser" <Stratuser(a)discussions.microsoft.com> wrote in message
news:5D68C499-0F97-4CC1-B154-4C95F5449CED(a)microsoft.com...
> In VBA, how do I specify the worksheet range that I want the chart legend
> to
> come from? My legend data is separated from my values data by several
> rows
> in the worksheet.


 | 
Pages: 1
Prev: Search Directories/SubDirectories and Display in ListBox or Ms
Next: XML and SharePoint