Attached is a spreadsheet of items that I monitored on a server that was recorded every 15 minutes.
I would like to produce a line graph for each column separately using the column 'snapshot' and show a separate line graph of each column individually from column 'B' to column 'AH' as separate charts.
So Chart1 would be Column A ('x' axis) and Column B ('y' axis), Chart2 would beColumn A ('x' axis) and Column C ('y' axis), Chart3 would be Column A ('x' axis) and and Column D ('y' axis), etc.
My problem is that I only want the chart to show an entry when there is a change to the value in the non-Column A column. In this way rather than show 875 Column 'A' items on the 'x' axis, there would be only a handful, but the 'y' axis would show the entire range of numbers for that particular column.
Thanks in advance for your assistance!