| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
graph
When I group data or hide data. The graph series dissappears and the graph
nolonger shows the data. Is there a way round this without just putting the data elesewhere |
|
#2
|
|||
|
|||
|
Hi,
Select the graph and then display the Options dialog via the menus Tools Options. On the Chart tab is a option to Plot Visible cells only. You need to uncheck this. Cheers Andy Mary wrote: When I group data or hide data. The graph series dissappears and the graph nolonger shows the data. Is there a way round this without just putting the data elesewhere -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| 2 axis bar graph | Excel Discussion (Misc queries) | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
Linear Mode
