Hi, i create a sample as per attached. I wanted the Chart to show only data that i put a "Yes" beside. I have use formula to generate the Net Data (using Name Manager (OFFSET formula) which shd be reflected in the Bar Chart.
However, when i remove/add Yes, i c that my Name Manager range work. BUt when the chart is not updating.
Anyone can advice why is this so?
Your can not use a named ranged that defines the whole of the chart data source at once.
Instead you need a named range for the labels and data of each series.
CHART_LABEL: =OFFSET(Sheet1!$H$2,,,Sheet1!$F$4,1)
CHART_DATA: =OFFSET(CHART_LABELS,0,1)
then use the select data dialog to enter the named ranges, which will then update the series formula to be
=SERIES(Sheet1!$I$1,'Chart Update With Name.xlsx'!CHART_LABELS,'Chart Update With Name.xlsx'!Chart_Data,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks