excel giving a #REF error while creating volume vs client type table
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Charts - Bar and Line Combination Chart
i dont know why its giving me this error im doing everything as done in the lec help would be appreciated thnx! (P.S. its not because of the year and month cells i checked it)
1 answers ( 0 marked as helpful)
Hi ROHAN,
thanks for reaching out! In the end of the formula instead of "Big-box" you should have the cell reference instead - $D42 in your case. Also make sure that you've fixed all the relevant sales, as otherwise you might not get an accurate result for the remaining cells in the table.
Let me know if this helps!
Best,
365 Eli