+ Reply to Thread
Results 1 to 2 of 2

Selecting a chart and changing it's style

  1. #1
    Registered User
    Join Date
    03-31-2010
    Location
    Utah, America
    MS-Off Ver
    Excel 2007
    Posts
    18

    Selecting a chart and changing it's style

    So, I just created a pivot chart from certain information, but now I need to be able to change the chart style (I want to make it the xlBarStacked style)

    This is my original code, and it works perfect,

    Please Login or Register  to view this content.

    I run into problems when I try to change the chart style, because each time I run the macro, the number of the chart changes and I'm not sure how to set the chart to a certain name, or how to keep the variables floating for the following code, which changes the chart style and one of the colors of the bars:

    Please Login or Register  to view this content.

    any suggestions?

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,015

    Re: Selecting a chart and changing it's style

    If that's part of the same routine, you have a variable (cht) that refers to the chart so you can use that. (similarly you have pt for manipulating the pivot table.
    Everyone who confuses correlation and causation ends up dead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1