Hi, I'm looking to create a dynamic chart from a vlookup table because the vlookup can return a different number of rows and I only want to chart the data the vlookup returns. I have tried an offset formula but this does not work because even if there is no data in a cell, the vlookup formula is still in that cell and the chart recognises this as a zero value and the chart displays this.
Hi,
We need to see your request in context.
You need to upload a workbook and describe your requirement with reference to specific cells and give examples of inputs and the results that flow from them.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks