When displaying an Excel chart in a Viewport, it is possible to select the chart object itself rather than the Excel range of cells which contain the chart.
The main advantage is that when the viewport size differs from the original chart size, the chart itself is re-drawn to the new dimensions rather than stretching the image. This will usually give a crisper display and avoid cases where legends and axes can look fuzzy.
This approach is particularly useful on Dashboard sheets, where the viewport size changes based on the device's screen size. Another advantage is that the chart automatically refreshes when the underlying data changes.
Web Limitations
Due to the way charts are resized:
- You can't have two viewports on the same chart on one sheet.
- But you can have them on different sheets.
- Charts may overlap standard range-based viewports.
- In this case, you can move the chart to a different sheet from the range viewport.
You can also add viewports based on Small multiple charts and Treemaps. These give the same benefits as viewports on Excel charts, improving the fuzziness of resizing the chart.
