Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting cells that have been grouped
When charting a large range of cells, which have been grouped in sets of 12
for convenience and easy review, the chart using this data is blank. If I ungroup the cells, the chart shows the data. Is there a way around this? Why can't a chart show the data even if the data is hidden? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting cells that have been grouped
I don't know what you mean by "grouped" cells. Are you hiding cells? By
default Excel doesn't display hidden data on a chart. To change this behavior: Select the chart, go to Tools menu Options Chart, and uncheck Plot Visible Cells Only. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Fuller" wrote in message ... When charting a large range of cells, which have been grouped in sets of 12 for convenience and easy review, the chart using this data is blank. If I ungroup the cells, the chart shows the data. Is there a way around this? Why can't a chart show the data even if the data is hidden? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |