+ Reply to Thread
Results 1 to 8 of 8

How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

  1. #1
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Example:

    Name:  timeline-with-today.jpg
Views: 7188
Size:  53.5 KB

    All has been done by watching this movie. Text instruction or any other things are not required.
    You can add rep if you like it

    no follow up

    see attached file:
    Attached Files Attached Files
    Last edited by sandy666; 07-09-2017 at 02:31 PM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Another way to add vertical "Today" line to linear chart



    Name:  lineartoday.jpg
Views: 6233
Size:  37.2 KB

    1. Add =TODAY() (A1 in example)
    2. Create line or scatter chart
    3. Add New Data Series and in series name type Today, in series value select A1, Ok, Ok, Chart will be selected
    4. Chart Tools, Format, Current Selection - select: series Today
    5. Chart Tools, Design, Type, Change Chart Type
    6. In new window change Today chart type to Scatter, Ok
    7. Chart Tools, Format, Current selection, select series Today
    8. Chart Tools, Design, Chart Layouts, Add Chart Element, Error Bars, More error bars option...
    9. (Vertical error bar) Error Bar Options, No Cap, Percentage: 100, Fill&Line, Color: Red, Width: 2
    10. Horizontal error bar: Both, No Cap, Fixed Value: 0
    11. Select Data, Today, Edit, Series X value: A1, series Y value: 1, Ok, Ok
    12. Chart Tools, Format, select series "Today", format selection, change to Secondary axis
    13. select Secondary Vertical (value) Axis
    14. Axis option: Minimum: 0, Maximum: 1, Major: 1
    15. You can add rep if you like it

    The rest up to you
    Attached Files Attached Files
    Last edited by sandy666; 07-14-2017 at 06:21 AM.

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    How to add vertical (average) line to bar chart


    Name:  averagevertical.jpg
Views: 6551
Size:  53.4 KB

    1. create bar chart
    2. Then go to a blank cell, here I select cell A10 to type Y, and then go to the cell next to the Y cell, here is Cell B10 to type X
    3. In the two cells below Y cell, type 0 and 1 in each cell
    4. Go to the cell below X cell, here is B11, type =AVERAGE($B$2:$B$9), then press Enter key and drag the fill handle to the next cell below it
    5. In Select Data Source dialog, click Add button in the Legend Entries (Series) section
    6. In the Edit Series dialog, type the new series name you need, and select B11:B12 (B11:B12 is the range you calculate average in step 4)
    7. Click OK > OK to close dialogs. Then select the new series you added in the bar chart, and right click to click Change Series Chart Type in context menu
    8. In the popped Change Chart Type dialog, select X Y (Scatter) > Scatter with Straight Lines, and click OK to exit the dialog
    9. select Combo section under All Charts tab, and select Scatter with Straight Lines from the drop down list in Average series, and click OK to exit the dialog
    10. Go to the chart and right click to click Select Data in the context menu again
    11. In the Select Data dialog, select Average series and click Edit
    12. In Edit Series dialog, select the X values and Y values range. (You just need to add the range cells below Cell Y and Cell X you have typed in step 3 to Y values and X values)
    13. Click OK > OK to close dialog. Then right click at the right Y axis (the secondary axis), and select Format Axis from the context menu
    14. In the Format Axis dialog, set Maximum: 1, Major: 1
    15. You can add rep if you like it

    in the same way you can add MIN and MAX vertical line

    The rest up to you
    Attached Files Attached Files
    Last edited by sandy666; 07-14-2017 at 06:22 AM.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Three Gantt bar charts with/without vertical "Today" line



    Name:  s666ganttbartoday.jpg
Views: 6533
Size:  37.4 KB
    • Basic manual Gantt chart with vline 'Today'
    • Gantt chart manual end date
    • Gantt chart manual duration

    Template has name: Do it yourself
    All what you need is above
    You can add rep if you like it
    Attached Files Attached Files
    Last edited by sandy666; 07-14-2017 at 06:22 AM. Reason: some series updated

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Simple Gantt 'Fish' chart with "Today" marker



    Name:  fish.jpg
Views: 6211
Size:  34.3 KB

    The rest as usual (see above)

    You can add rep if you like it
    Attached Files Attached Files
    Last edited by sandy666; 07-14-2017 at 06:22 AM.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Vertical line chart with positive and negative line markers



    Name:  audit.jpg
Views: 6114
Size:  64.9 KB

    1. create source table (basic is: B2:D10 and I2:K10 with values - check formulas)
    2. create chart scatter with smooth lines and markers
      1. add first serie Nord
      2. add second serie from Average
      3. add third serie from #
    3. change chart type to Combo and serie # to Stacked Bar
    4. change Horizontal (Category) Axis Labels to Audit values
    5. change bars fill color and lines color to none
    6. add two columns with negative and positive values (Nord - Average)
    7. add error bar for Nord serie, remove vertical element and change direction to minus and no cap then Error Amount - Custom - Specify Value - from column (-)
    8. do the same for for Average serie but Specify Value - from column (+)
    9. format error bar for Nord to red (negative) and for Average to green (positive)


    Name:  1-2serie.jpg
Views: 6028
Size:  48.4 KB
    Name:  customerrorbars.jpg
Views: 5972
Size:  16.7 KB
    Name:  thirdserie.jpg
Views: 6028
Size:  45.5 KB


    The rest up to you, add more bells&whistles if you wish.

    (NOTE: this is not detailed instruction step-by-step, you need to think )

    If you like it - click Add Reputation (bottom left corner of this post)
    Last edited by sandy666; 07-23-2017 at 05:16 AM.

  7. #7
    Registered User
    Join Date
    08-10-2017
    Location
    Malaysia
    MS-Off Ver
    MS 2013
    Posts
    2

    Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Thank you for sharing these various types of timelines.

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Simple doughnut chart - skills



    Name:  skills.jpg
Views: 6105
Size:  10.3 KB
    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] today() in Excel 2010 32 bit vba returns different value than Excel 2016 64bit
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2016, 12:34 PM
  2. Multiple questions about Excel project timeline, % formulas, refresh timeline
    By Please Help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2016, 07:13 PM
  3. Replies: 5
    Last Post: 04-01-2016, 02:05 PM
  4. [SOLVED] Vertical Timeline
    By lyla22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2015, 01:57 AM
  5. Project Plan / Timeline - lookup date by searching 'x' marker
    By smudgepost in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2014, 09:40 AM
  6. Windows 8, Excel 2013 and Project 2010 - Reference Error in Macro
    By microsoftexcel007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 06:23 PM
  7. Create vertical line for today
    By aaslezak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2013, 12:05 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