I have added a target series as a line on a combo chart to my bar chart, but the line doesn't extend the entire width of the chart.
Is there a way to make it extend all the way rather than the centre of the left and right-most bars?
Capture.JPG
I have added a target series as a line on a combo chart to my bar chart, but the line doesn't extend the entire width of the chart.
Is there a way to make it extend all the way rather than the centre of the left and right-most bars?
Capture.JPG
Last edited by kersplash; 11-12-2018 at 02:57 AM. Reason: added sample file
Found an answer here;
https://peltiertech.com/Excel/Charts...orzSeries.html
G'day kersplash,
Have I made you happy ??? If yes, please make me happy by pressing the Add Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Thanks ratcat,
But it's not a trendline, it's a target line.
This is handy to know. Will be using soon! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks