Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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

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
Old 01-09-2019, 09:41 AM
Trapshooter1956 Trapshooter1956 is offline Windows 7 32bit Office 2007
Join Date: Mar 2017
Posts: 21
Trapshooter1956 is on a distinguished road

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

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

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:43 PM.

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