+ Reply to Thread
Results 1 to 2 of 2

% change between two fiscal years sticky to bars within chart?

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    % change between two fiscal years sticky to bars within chart?

    Hi,

    I have recently developed a "dashboard" within an Excel file with huge amount of data to summarize some of the key figures. I have included "buttons" to switch among regions by having a macro changing formulas in the cells where each chart is taking its data from.

    example clean.PNG

    Though, whenever I switch to another country, the % change between two fiscal years moves uncontrollably around (see below), which makes it unreadable/ useless. It would be a pain and not very user friendly to change it manually every time. Is there a way to make the % changes "stick" to the corresponding bar chart? I'm currently using a bar chart (sales value) and line chart (% change), where the line itself is hidden as I just want to see the percentages but on top of the right bar. Is there a way to do that? or does Excel not have such a feature? Does anyone know? been trying to figure this out for quite some time now...

    example messy.PNG

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: % change between two fiscal years sticky to bars within chart?

    Not quite sure how the hidden line with percentages is supposed to work. Since you are already using VBA, you should be able to change the text for the bar chart data points. You can hardcode whatever you want. Something like this:
    Please Login or Register  to view this content.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. VBA to change color of bars in a pivot chart
    By seanpod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2017, 10:20 AM
  2. Stacked Chart with change between two Bars
    By Heidepark in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-08-2016, 07:55 AM
  3. Formula's using fiscal years
    By etherplain in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2015, 08:06 PM
  4. Excel 2007 : Change width of chart's bars
    By SueWithQuestion in forum Excel General
    Replies: 7
    Last Post: 07-10-2014, 03:23 PM
  5. how do you change bars into lines on a chart
    By BJ in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-16-2006, 06:20 PM
  6. Pivot Table Fiscal Years
    By Sadie in forum Excel General
    Replies: 1
    Last Post: 11-16-2005, 05:15 AM
  7. [SOLVED] working with dates in fiscal years
    By justin_vasko in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2005, 04:06 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