Forum Discussion
Secondary axis crashing excel
This is going to be difficult to pull off without aggregating the data before charting it. 125,000+ data points is too much for even 64 bit Excel. In attempting to rebuild your chart using the table and not query, Excel would not accept the entirety of those tall columns.
A workaround might be to aggregate your data with a pivot table first.
Time-Diff in the row labels - grouped by hour and minute
'detected' and 'noise power' in the values - Summarized by average
Then the line chart becomes do-able:
If you need the visuals to be more granular (with more data points) then this may not work but it's an option.
This is going to be difficult to pull off without aggregating the data before charting it. 125,000+ data points is too much for even 64 bit Excel. In attempting to rebuild your chart using the table and not query, Excel would not accept the entirety of those tall columns.
A workaround might be to aggregate your data with a pivot table first.
Time-Diff in the row labels - grouped by hour and minute
'detected' and 'noise power' in the values - Summarized by average
Then the line chart becomes do-able:
If you need the visuals to be more granular (with more data points) then this may not work but it's an option.