i have a tabulation which is as show below.
|Region||FTD TY Qty||FTD TY Val||MTD LY Qty||MTD LY Value||MTD Qty Growth||MTD TY ACH%||Target||MTD TY Qty||MTD TY Val||MTD Val Growth|
i want to represent the values in bar graph and the growths in line in the single worksheet.Please help
we can go with pivot or else use calculations in sql and make it.
In your case need to show with three measures in one side and three diff measures in one side.