+ Reply to Thread
Results 1 to 2 of 2

Select All Charts in Excel Workbook?

  1. #1
    Registered User
    Join Date
    03-05-2020
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1

    Select All Charts in Excel Workbook?

    I have a workbook that has 25 tabs with each worksheet containing about 2-5 graphs. What is the best way select all the graphs in the different tabs at once? The end goal is to copy all the graphs so I can move it into Word to finish up a report.

    I've tried selecting all of them via F5 Go to > Objects, but that only selects graphs in the current worksheet. I have tried substituting any code I've found for select graphs in one worksheet and that didn't really lead me anywhere...(probably because I'm also not very well-versed in VBA).

    Thanks for your help!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,908

    Re: Select All Charts in Excel Workbook?

    You can't select objects (charts, range etc) that are not in current sheet (i.e. ActiveSheet).

    You'll need to iterate over worksheets and then loop over chart objects to export.

    I'd recommend uploading sample workbook and sample expected output (Word file).

    If unable to... you can use Jon Peltier's code as basis, you just need add loops to check each worksheet in the workbook and each chart in a worksheet.
    https://peltiertech.com/export-excel-chart-word/
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying select Excel charts to locations in PowerPoint
    By rmunoz5 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2017, 12:38 PM
  2. On select, Transfer the information to new Workbook (Excel 2003)
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 01:32 PM
  3. Replies: 0
    Last Post: 07-05-2012, 03:44 PM
  4. how to select range of values from excel sheet and write to different workbook
    By kottam_reddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2012, 06:51 AM
  5. Replies: 1
    Last Post: 12-29-2005, 10:11 AM
  6. Excel Charts do not update when Workbook recalculated
    By duane in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-27-2005, 06:55 PM
  7. [SOLVED] Excel charts should let me select a range for data labels.
    By Relmbo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2005, 10:05 AM

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