I have created a standalone dashboard chart wherein the data is just inside the excel file.
The formula i used for a certain group of cells is VLOOKUP.
When i link the chart to the cells, the chart shows data properly. But when i click on preview, there is no data.
Can anyone help me with this?
Thanks in advance,