Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
268
Views
Topic starter
Hi Admin,
How do we have a dotted line separator on a normal distribution curve (graph).
There are 6 factors in x-axis, & I want to group them into 3 (ie : A&B, C&D, E&F). Do refer attachment.
Please help 🙂
Thank you.
Posted : 11/02/2017 12:34 am
Hi Ahmad,
You can create a nested axis by referencing two columns for the horizontal axis range. See example attached.
Note: I don't recommend using smoothed lines since the top/bottom of the line can often appear higher/lower than the actual point. For example, the Actual line in your chart appears to max as 44% but the actual max is 42%. The oragne line appears to peak much higher than the target.
Kind regards,
Mynda
Posted : 12/02/2017 6:35 am
