Forum Discussion
which chart will help for displaying the % status ?
Hi Experts,
I want to showcase some scope of the tasks with % calculations. No x axis , y axis logic here.
I have all the calculations in hand but i don't know which graph will be suitable for it .
Demo from excel :
In total of 100% , 83% is yet to plan , 17% is planned = 100% done
13% is completed in 17% planned.
It same like stacked bar chart but here we cannot use as there is no x axis , y axis concept.
The graph which i am expected is : 13% value should come inside 17% , but total will be 100% only
13+17+83 is not a logic , 17+83 is the scope , among 17% 13% is completed.
Currently i have tried tunnel chart and it shows like this only , not meaningful ..
Hope my query is understandable.
Please help to achieve this asap.
Thanks
DK
4 Replies
- rajendraongole1
Super User
Hi Anonymous - Can you try Bullet Chart visual is more appropriate, it can automatically resize the axes.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rajendraongole1 Thanks for your response 🙂
But i have only 3 values to showcase in the graph , but this charts are having more parameters and totally confusing to me .
My input for example :
Target : 100%
Pending : 93%
Planned : 7%
Delivered : 4%- rajendraongole1
Hi Anonymous - can you try with adding a 100% Stacked Bar Chart:
Select the 100% stacked bar chart from the Visualizations pane.
Add "Category" to the Axis.
Add "Percentage" to the Values.
This will provide a clear visual representation of how Pending, Planned, and Delivered contribute to the total Target.Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
