+ Reply to Thread
Results 1 to 2 of 2

How to adjust chart with the formula function?

  1. #1
    Registered User
    Join Date
    03-15-2023
    Location
    nowhere
    MS-Off Ver
    365
    Posts
    11

    How to adjust chart with the formula function?

    Please see my dummy template attached here - I have already applied the formula on Section A to equal matching results based on Section B however I need help on how to adjust the chart (Section A) with the remaining difference from Section C aswell. I plan to insert Section D, E, F, etc onto the table over time.

    Please let me know if possible to adjust. I am open to use vba, macro if necessary. I use excel 365.


    Thank you kindly.
    Attached Files Attached Files
    Imadeasignaturebecausenopostlookscompletewithout1.

  2. #2
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,505

    Re: How to adjust chart with the formula function?

    A better layout will make calculations easier. Now you have to work with offsets
    You can select your section in the dropdown.
    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)

Similar Threads

  1. [SOLVED] Using VBA to adjust chart scales
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2014, 09:15 AM
  2. adjust logarithmic scale + adjust chart
    By voltaire101 in forum Excel General
    Replies: 5
    Last Post: 08-05-2010, 08:12 PM
  3. how to adjust chart series formula to include the "indirect" function
    By luv2glyd in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 06-13-2010, 07:35 AM
  4. Replies: 6
    Last Post: 06-04-2010, 11:55 AM
  5. Adjust chart size
    By nsv in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2007, 06:52 AM
  6. Adjust chart size
    By nsv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2007, 07:11 AM
  7. Adjust Chart Size
    By nsv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2007, 04:17 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