Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #16  
Old 01-09-2019, 08:16 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 409
ArviLaanemets will become famous soon enough
Default

You always can make a separate table for chart - on same worksheet where chart is situated, or another sheet. You get all data needed for chart there (Only needed data!). Chart will be based on this table, not on table meant for users. You can leave this table visible, or hide it from users (when on separate sheet, then you can hide sheet, when on same sheet with chart, then you can hide columns/rows with table).
Reply With Quote
  #17  
Old 01-09-2019, 09:41 AM
Trapshooter1956 Trapshooter1956 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2017
Posts: 21
Trapshooter1956 is on a distinguished road
Default

Thanks, That should work.
Reply With Quote
  #18  
Old 01-10-2019, 12:18 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please mark the thread solved if this answer is what you need
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
PPT 2010 - Animated Chart by Series - Animations reset when editing chart agaudet21 PowerPoint 0 10-12-2017 06:18 AM
MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table billcary Project 3 09-22-2014 07:10 AM
Question - Chart dapaq2 Word 0 01-03-2013 01:30 AM
Newbie Question - Chart Data KarynHill PowerPoint 6 01-08-2012 07:22 AM
Outlook chart question projecttoday Outlook 0 11-11-2011 11:29 AM


All times are GMT -7. The time now is 07:24 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft