nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Milestone Trend Analysis

Stephan Schmitz_ydjz49

Hello All-together,

as a project manager I would like to generate a chat representing the milestone prediction to a certain date. As a figure is more worth than a word....I am looking for something similar like this.

How must my table look like and how to set up the tool "chart from table" to retrieve a similar figure?

I am very much looking forward for some hints and ideas!

Thank you

Stephan

Accepted answers

Katerina Rudkovskaya _Stiltsoft_

Hi @Stephan Schmitz,

I can suggest the following workaround using the Line chart:

Wed 12-1.png Wed 12-2.png Wed 12-3.png Wed 12-4.png

Неre you use full months’ names as X-axis values and set numeric values from 1 to 12 that correspond to the months’ numbers for Y-values.

Also you may check our Gantt chart that is rather advanced and may be more suitable for the project tracking.

All comments

Katerina Rudkovskaya _Stiltsoft_

Stephan Schmitz_ydjz49

Dear @Katerina Rudkovskaya _Stiltsoft_ ,

thank you very much for the time spent on my problem, I really do appreciate it. Your tip helped me to get further. It dawned to me that I must somehow modify my requirements and came up with the following.

I changed the months into a date (x-axis) and the project timing I started to count in months (y-axis). Now I can see how different milestones are progressing over time.

However I am not able to modify the x-axis into month year scaling, it stays with date month year...but I can live with that.

thanks for your help

Stephan

Katerina Rudkovskaya _Stiltsoft_

You can change the date format in the Reporting column of your source table to have it in the x-axis of the chart then. It's possible to do with the help of Table Transformer.
Please see the example below:

Stephan Schmitz_ydjz49

Dear @Katerina Rudkovskaya _Stiltsoft_

thank you very much for your help!

Stephan

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

filter

table

chart

gantt

table-filter

table-filter-and-charts

project-management

milestone

chart-from-table