| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I keep my chart from changing when excel has autofilter?
I made a chart while the excel sheet is in autofilter and hide. Is there a
way to lock the chart or prevent its changing when the hidden items are unhidden. Not sure what will happen with autofilter. Will it do the same thing? In other words change my graph? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I keep my chart from changing when excel has autofilter?
click on the chart and hold shift and click edit, and copy then paste as a
picture -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "asg2307" wrote: I made a chart while the excel sheet is in autofilter and hide. Is there a way to lock the chart or prevent its changing when the hidden items are unhidden. Not sure what will happen with autofilter. Will it do the same thing? In other words change my graph? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I keep my chart from changing when excel has autofilter
Thanks ,this will work and I can see this is a perfect way to use it for
PowerPoint. "john" wrote: click on the chart and hold shift and click edit, and copy then paste as a picture -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "asg2307" wrote: I made a chart while the excel sheet is in autofilter and hide. Is there a way to lock the chart or prevent its changing when the hidden items are unhidden. Not sure what will happen with autofilter. Will it do the same thing? In other words change my graph? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHANGING POSITION OF AUTOFILTER LIST | Excel Discussion (Misc queries) | |||
| Excel chart, changing into sections to color | Charts and Charting in Excel | |||
| Changing Time Scale to Seconds on Excel Chart | Charts and Charting in Excel | |||
| Dynamic Chart With Autofilter and Formulae | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Linear Mode
