Why do my graphs disappear?

J

jimbo125

Board Regular
Joined
Jan 23, 2010
Messages
98
Office Version
  1. 2011
Platform
  1. Windows
I have an excel file with graphs on sheet 1 and the formulas for the graphs on sheet 2.
When I try to hide the formula's on sheet 2 the graphs on sheet 1 disappear.
Can anyone give me any pointers as to why.

Thanks,

Jimbo.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
Go to Tools|Options|Chart and untick the "Plot visible cells only" box.

Don't you love it when something like this gets hidden somewhere really obscure!
 
Upvote 0
Which version of Excel? Also, do you mean that the charts disappear, or that no data is visible? If it's the latter, and you are hiding the cells that contain the formulas, then that is the default behaviour but you can change it - we need to know the Excel version to give specific instructions though.
 
Upvote 0
In 2007 the steps are:
1. Select the chart
2. On the Design tab, click the Select Data button, then click the 'Hidden and Empty cells' button on the dialog.
3. Check the 'show data in hidden rows and columns' option.
 
Upvote 0
I am having the same problem but with Excel 2013. Embedded graph disappear sometimes when I open my sheets. Please help.
 
Upvote 0
Right click on the chart, choose Select Data. Click the Hidden and Empty Cells button at the bottom left, and check Show Data in Hidden Rows and Columns.
 
Upvote 0
Hi Jon,

I am unable to right click on the chart as it has disappeared. Some sheets are fine. Others, have disappeared.

Amanda
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Pull Data from Multiple Excel Files into a Summary Excel File to Create Graphs
2
Replies
11
Views
311
NdNoviceHlp
NdNoviceHlp
Y
  • Question Question
A macro to change formatting of 27 graphs
Replies
2
Views
80
yabi100
Y
H
  • Solved
Graph data series named range challenges - terribly frustrating
Replies
2
Views
73
hcgood
H
S
  • Question Question
Making a graph connect
Replies
0
Views
56
Serrre
S
A
  • Solved
referenced blank cell returned zero (0) as values
Replies
5
Views
510
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,506
Messages
6,179,159
Members
452,892
Latest member
yadavagiri

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top