Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart Excel - Title bigger than 32 chars. and option" Vary colors by "

Status
Not open for further replies.

bogtom

Programmer
Jun 11, 2001
31
US
two questions:
- how I insert a title into an Excel chart bigger than 32 characters ? prop: chart1.Title
- how I can set the option "Vary colors by point" (coloring the column different) from "Format data series" on On (or TRUE) with the editor Visual Basic because I didn't found a property of the object Chart which can refer to "Vary colors by point"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top