+ Reply to Thread
Results 1 to 3 of 3

Graph - Actual and Projection

Hybrid View

ramsdesk Graph - Actual and Projection 11-18-2011, 06:48 PM
shg Re: Graph - Actual and... 11-18-2011, 07:46 PM
Andy Pope Re: Graph - Actual and... 11-19-2011, 06:16 AM
  1. #1
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    72

    Graph - Actual and Projection

    Need help..

    I want to show the actual results along with future projection in one line graph. The actuals as a solid line with perhaps different color and the projection as a dotted line with another color.

    For eg: the sales for Q1 and Q2 can be shown as a solid line and the future sales projection for Q3 and Q4 shown as dotted line.

    Is this possible?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Graph - Actual and Projection

    Plot one series for actuals and a second for forecast, and format each as you like.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Graph - Actual and Projection

    Here's an old example.
    http://www.andypope.info/ngs/ng45.htm
    Cheers
    Andy
    www.andypope.info

+ 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