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
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks