View Single Post
 
Old 09-16-2020, 01:32 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Jun 2020
Location: Essex
Posts: 102
Purfleet will become famous soon enoughPurfleet will become famous soon enough
Default

I assumme there is an offical way of doing it, but i only know this way and while it works there are some limitations.

so a further cheat...

Put the data on sheet2, base your graph with a target on sheet 2 then just link the bits you want to show on sheet1

see attached

let me know if its what you were after
Attached Files
File Type: xlsx practise sheet)_Purfleet2.xlsx (18.8 KB, 1 views)
Reply With Quote