LinkBack URL
About LinkBacks
Hello.
I have several rows that are grouped togheter. I use values from these rows in a chart.
When I close the group the "chart" dissapears.
Is there someway to override this? I want to hide the rows but still use the values hidden.
/Anders
Hello.
I have several rows that are grouped togheter. I use values from these rows in a chart.
When I close the group the "chart" dissapears.
Is there someway to override this? I want to hide the rows but still use the values hidden.
/Anders
How about setting the row height to 1, this nearly hides it, but keeps the data in the chart?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Hello.
Yes, that is an easy solution to my problem. Unfortunately the document I have created will be used by many people and it can be frustrating for some inexperienced person when they don't see the values.
I believe the grouping function is easier.
/Anders
The only way round this is to copy the data table ( from sheet1) to another sheet (sheet2) and form the chart from data on sheet2. Hide sheet2, then hide the grouped data in the table on sheet1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks