Hi all,
The chart plots the whole data series including cells which are "".
What can I do to make the chart auto adjust accordingly to only cells which have values?
I am very keen to learn.
Hi all,
The chart plots the whole data series including cells which are "".
What can I do to make the chart auto adjust accordingly to only cells which have values?
I am very keen to learn.
Last edited by WalaVita; 05-01-2020 at 09:34 AM.
Try the dynamic chart ranges outlined here: https://exceljet.net/chart/dynamic-c...e-empty-values
I created two names (press CTRL+F3):
Name: Age
Refers to: =Sheet1!$C$3:INDEX(Sheet1!$C$3:$C$32,COUNT(Sheet1!$C$3:$C$32))
Name: Savings
Refers to: =Sheet1!$D$3:INDEX(Sheet1!$D$3:$D$32,COUNT(Sheet1!$D$3:$D$32))
Right-click chart and choose Select Data.
Below 'Legend Entries (Series)' click Edit.
Set 'Series Name' to: =Sheet1!$D$3
Set 'Series Values' to: =Sheet1!Savings
Click OK
Below 'Horizontal (Category) Axis Labels' click Edit.
Set 'Axis Label Range' to: =Sheet1!Age
Click OK
Click OK to return to your worksheet/chart.
Thanks Sir! You are a champion!
I am a newbie to advanced formulas, only started last year to do up a planner for my clients.
I am very keen to learn more!
So now i will need to find out how i can input your guidance into my planner.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks