+ Reply to Thread
Results 1 to 1 of 1

Save Chart As Image + Auto Title Text

  1. #1
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Save Chart As Image + Auto Title Text

    Thanks to mrice I've now got the auto chart creation working well. Now I want the "Title" text of the chart to be deleted & to copy the text from a cell as it's name. It'll be the month of the chart being created. I've got the reference cell text part sorted.

    After the chart has been created I would like a way to either save it as an image, or lock it. The cells that show the data to create a chart can be called up whenever I want. I type the 1st of a month in a cell & all the data of that month appears. I create the chart. But when the data is changed by calling up a different month, the chart changes.
    I've tried a Hyperlink to call up Paint & save it there. But there's a security "Nag" that appears & I can't get rid of it. I tried the MS solution, which didn't work, + it's a convoluted way of doing it.
    It's something I'm doing for a friend who's frightened of his computer & fully automated is the way he'd like it to be
    I've attached a sample
    Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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