+ Reply to Thread
Results 1 to 5 of 5

Chart automation

  1. #1
    Registered User
    Join Date
    01-13-2022
    Location
    Motta di Livenza, Italy
    MS-Off Ver
    Excel 2016
    Posts
    20

    Chart automation

    Hello there,

    I?m trying to automate a chart, but without success so far.

    As you can see from the attachment:

    ? Columns C & D = comparison between different interest rates
    ? Column A = reference month
    ? Column B = Currency

    I would like to create a chart (Clustered column) to compare the 2 interest rates for every currency, for specific dates. Therefore, I want to insert a slicer and a timeline, that would allow me respectively to select a currency and select the month for which I want to see the comparison.

    How can I implement that? Can somebody help me please?

    Thanks allot in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B 2016
    Posts
    1,902

    Re: Chart automation

    Is that what you are looking for?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-13-2022
    Location
    Motta di Livenza, Italy
    MS-Off Ver
    Excel 2016
    Posts
    20

    Re: Chart automation

    Thanks a lot for your reply. That's a good idea, but I actually need to create a chart, and I cannot do it from a Pivot Table, but essentially it should behave exactly as your Pivot Table is doing.

  4. #4
    Registered User
    Join Date
    01-13-2022
    Location
    Motta di Livenza, Italy
    MS-Off Ver
    Excel 2016
    Posts
    20

    Re: Chart automation

    Sorry, I forgot that PivotCharts do exist ahah.

    Thanks a lot!

  5. #5
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,529

    Re: Chart automation

    alternative for those without 'pivot charts'
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. [SOLVED] how to automation on Y axis chart with multiple sheets wiith different value
    By noelcjf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2021, 03:11 AM
  2. Help! Multiple Chart Data Update Automation
    By zjtaylor85 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-29-2014, 04:41 AM
  3. Chart Data Range Automation
    By mcmuney in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2010, 09:52 PM
  4. Gantt Chart Help with Conditional Formatting Automation
    By starbwoy in forum Excel General
    Replies: 9
    Last Post: 12-15-2009, 06:45 PM
  5. Automation of Dynamic Chart Title and legend changes
    By Boon8888 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2006, 07:10 PM
  6. Chart Automation
    By SteveG in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-02-2005, 03:48 PM
  7. [SOLVED] Using automation to add xy scatter chart
    By Geographer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2005, 12:10 PM

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