I wonder if someone can point me in the right direction, but I'm having trouble working out how to add data to create a sparkbar.
I have a 8 systems where backups are performed and I have data on each system, each day and whether it was a success (1 or 0). I can't work out how to create a table with a list of systems and then a sparkbar (or WinLoss). I have the raw data pulling into a pivot table then uploaded via email so I can move around the data to a better shape. I've tried :
- System in column A, dates as row 1 and data to plot (1 or 0) as rows.
- System in column A, dates in column B and data to plot (1 or 0) as column C
Can someone point me at a help file or even a picture of how I'm meant to set this up !!