'How do I graph data from hidden cells?
The black area contains a graph, when I hide the data the graph vanishes.
I can still click on the graph and check/uncheck the "Show data in hidden rows and columns" box and I can also check the "Select data source tab" to confirm the data is still selected but it never actually appears.
What's going on and how do I fix this?
With cells hidden:
With cells un-hidden:
Confirming data sources still selected:
Solution 1:[1]
If your chart intersects with the rows or columns being hidden then that is most likely the issue. Right click the chart>Format Chart Area>Size & properties, then selecte something other than "Move and size with cells."
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Basbadger |