I got a large data base where I have tickets data. Now I was looking for something like this tableau (see ss below), however couldnt manage to do it.
Instead I ended up creating different workbook for each ROW below and then manually copied it into MS Excel and added the trend line. I tried creating a dashboard out of my worksheets, but aesthetically it looks real bad. Is there any way I can get data in such format in one worksheet. Remm every row has its own calculations.
It would really depend on how difficult "every row has its own calculations" means.
Could you provide some sample/dummy data ? I'm sure there is a way to do it in a single sheet but need more explanation to understand the problem.