+ Reply to Thread
Results 1 to 2 of 2

Add average of past years to plot of current year

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    don't know where i am
    MS-Off Ver
    Excel 2003
    Posts
    15

    Add average of past years to plot of current year

    Hi,

    My boss asked me to make some graphs with data of our operating ratio (%) .
    It should contain the a value for every month of this year and a value for every past year.
    The issue i get is that only the last 20% of the graph is really of importance since this contains the data of the current year.
    The first 80% is only 1 point per year and is older data.
    I've been trying to fix this but i can't find any documentation about it.

    Anyone who can give me a tip about this?

    I attached an example of the graph.
    The data is confidential so i could not add this .

    Kind regards,
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Add average of past years to plot of current year

    Hi,
    Have you tried to change chart type from scatter to line (with formatting as markers only, no lines, and horizontal axis formatted as text type - not date)?
    If not - try it.
    I cannot do it with your file, as it contains links to external data, but see sample file attached.
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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 subtract number of years from current year.
    By MaryLouJW in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-26-2018, 01:51 AM
  2. [SOLVED] Conditional Formatting for Past Due Dates for current Year
    By rz6657 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-20-2016, 02:03 PM
  3. [SOLVED] Sum last years data if current year has data
    By maw230 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-28-2016, 11:37 AM
  4. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  5. Pivot Table Year to Date for Current and Previous Years
    By BFid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2013, 05:28 PM
  6. [SOLVED] years change to current year
    By nwg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-01-2006, 11:35 AM
  7. Replies: 6
    Last Post: 04-06-2005, 10:06 AM

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