graph

M

Mary

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
 
A

Andy Pope

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
Click to expand...
need to uncheck this.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic graph 0
Plotting Graph with dynamic table 3
Getting the graph style I want 4
Overlay line graph points on bar graph 1
Hide line and legend when data not present 0
exporting data from a graph 0
Automatic Macro to create 200 graphs 1
Show only specific Series in the data table 1

Top