Notifications
Clear all
Excel Dashboards
4
Posts
2
Users
0
Reactions
79
Views
Topic starter
Hi!
As you can see in the attachment I have a simple chart with a Target bar. But as you can see the Target bar position is not in relation to the other chart values. Any ideas how to change this?
Cheers,
Martin
[Image Can Not Be Found]
Posted : 30/07/2016 12:20 am
Topic starter
Trying with the attachment again!
Posted : 30/07/2016 12:22 am
Hi Martin,
Setting a target line in a bar chart is tricky because you can't create a combo bar and line chart. I see that your vertical axis contains months and since they don't take up a lot of space I'd change this to a column chart with a line for your target.
Otherwise I'd have to see your file to understand how you tried to insert that line.
Mynda
Posted : 30/07/2016 12:34 am
Topic starter
Thanks for the tip Mynda..................Martin
Posted : 30/07/2016 1:08 am