Chart Area visible but cannot access rows and columns on worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Milate2 - 16 Jan 2008 21:05 GMT

I have a graph in an Excel spreadsheet and the entire area of the graph are
all gray. The row and column heading are not visible - the entire area around
the chart is grey. If I am in a preview mode I can't change it because the
option to select Normal or Page Break Preview is not present when view is
selected. When I tried to add the Normal View (via Customize Toolbars) the
icon was gey and non-functional. The chart appear to properly display and
print. The workbook has other charts on other sheets that function normally.

Reply to this Message

Jon Peltier - 16 Jan 2008 21:20 GMT

This is a chart sheet, not an embedded chart. It stands alone, without an
underlying worksheet. You can move it to a worksheet using Location on the
Chart menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>I have a graph in an Excel spreadsheet and the entire area of the graph are
> all gray. The row and column heading are not visible - the entire area
[quoted text clipped - 5 lines]
> print. The workbook has other charts on other sheets that function
> normally.

Reply to this Message

Milate2 - 23 Jan 2008 01:57 GMT

Thank you!

> This is a chart sheet, not an embedded chart. It stands alone, without an
> underlying worksheet. You can move it to a worksheet using Location on the
[quoted text clipped - 16 lines]
> > print. The workbook has other charts on other sheets that function
> > normally.

Reply to this Message