Oct 30, 2012 #1 Chris559 Instructor Dec 29, 2002 30 GB Is it possible to put a sparkline above the chart showing a percentage rise/fall?
Oct 30, 2012 Thread starter #3 Chris559 Instructor Dec 29, 2002 30 GB Thanks. Do you know how to do it? I am struggling! Upvote 0 Downvote
Oct 30, 2012 1 #4 M mintjulep Technical User Aug 20, 2004 1,551 JP On your worksheet you'll need to create a new column (or row) of data with whatever calculations you want to show. Add that to your chart as a new series, possibly using secondary axis. Or add a second chart and arrange as you like. Upvote 0 Downvote
On your worksheet you'll need to create a new column (or row) of data with whatever calculations you want to show. Add that to your chart as a new series, possibly using secondary axis. Or add a second chart and arrange as you like.
Oct 31, 2012 Thread starter #5 Chris559 Instructor Dec 29, 2002 30 GB Many thanks mintjulep - works a treat! Upvote 0 Downvote