Forum Discussion
Secondary axis crashing excel
Dear Experts,
Could you please help in this issue, that when I add Secondary axis, it's crashing excel.
I don't have the option to "Disable graphics hardware acceleration check box" in my version.
Thanks in Advance,
Br,
Anupam
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.
1 Reply
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.