ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel graph and display (https://www.excelbanter.com/excel-discussion-misc-queries/138432-excel-graph-display.html)

Kim K

Excel graph and display
 
I received a spreadsheet that has only the graph displayed with no cells,
gridlines or anything but this nice graph, most of my toolbar options are
greyed out adn I can not figure out how to toggle off this tpye of display so
that the cells are visible and I can alter this graph. My only option is to
right click on the graph to alter the graph but no page options are
availalbe. How am I albe to see the cells and such on this spreadsheet?
--
Thanks,,
Kim

Jon Peltier

Excel graph and display
 
The chart may be the type that exists on its own sheet, without any of the
grid found on a worksheet. The data is on another worksheet, which may or
may not be part of the workbook you have. To look for hidden sheets, go to
Format menu Sheet Unhide. If there are no hidden sheets, you have to
contact the sender of the chart for the data.

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


"Kim K" wrote in message
...
I received a spreadsheet that has only the graph displayed with no cells,
gridlines or anything but this nice graph, most of my toolbar options are
greyed out adn I can not figure out how to toggle off this tpye of display
so
that the cells are visible and I can alter this graph. My only option is
to
right click on the graph to alter the graph but no page options are
availalbe. How am I albe to see the cells and such on this spreadsheet?
--
Thanks,,
Kim





All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com