+ 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
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

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

    Example:

    Name:  timeline-with-today.jpg
Views: 69
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 (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    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: 55
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
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    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: 56
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
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    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: 51
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
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    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: 47
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
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    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: 34
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: 36
Size:  48.4 KB
    Name:  customerrorbars.jpg
Views: 34
Size:  16.7 KB
    Name:  thirdserie.jpg
Views: 35
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
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

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

    Simple doughnut chart - skills



    Name:  skills.jpg
Views: 15
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)

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