nbrophywilliams
New Member
- Joined
- Apr 9, 2015
- Messages
- 18
Hello,
I'm looking for help in creating a chart that will autofill according to results produced by a pivot report. I've succeeded thus far, but am nowing facing the difficulty of data in my pivot table producing either four rows of data or five rows of data. Is there a way that I can make my chart automatically adjust to whether there are four or five x values (i.e. remove the fifth data point if it is blank or zero)? This will save further processing down the track!
A screenshot of my problem can be found here (https://app.box.com/s/impdotzhmw5iznihftk5t7bezqx8xob5). The fifth variable (sometimes present, sometimes not) is highlighted in yellow.
Thanks in advance for your help,
nbw
I'm looking for help in creating a chart that will autofill according to results produced by a pivot report. I've succeeded thus far, but am nowing facing the difficulty of data in my pivot table producing either four rows of data or five rows of data. Is there a way that I can make my chart automatically adjust to whether there are four or five x values (i.e. remove the fifth data point if it is blank or zero)? This will save further processing down the track!
A screenshot of my problem can be found here (https://app.box.com/s/impdotzhmw5iznihftk5t7bezqx8xob5). The fifth variable (sometimes present, sometimes not) is highlighted in yellow.
Thanks in advance for your help,
nbw