I am using below formula to get the values to populate a Line chart, but I am not able to see the values on preview screen:
=INDEX($D$6:$D$18,MATCH($D$22&$F11,INDEX($C$6:$C$18&$B$6:$B$18,0),0),MATCH($D$25,$D$5:$D$5,0))
Line chart is mapped to the cells: H11 to H23 in the excel sheet.
Attached is the Excel sheet.
Any help will be greatly appreciated. Thanks in advance.
Using: Dashboard Version 4.1 SP2
LineChart1.xls (360.0 KB)
sha739 (BOB member since 2009-03-29)
I don’t think there’s anything wrong with the formula. Have you changed the chart value properties to display as decimals or percentage? That has happened to me before. Also, you could check the scale of the chart - do you have it set to auto scale or have you manually entered values for the scale?
~Roxanne P
Sr BI Consultant
Infosol
RoxanneP 
(BOB member since 2006-08-07)
That is strange behavior. I was not able to get it to populate a line chart either.
I have attached a workaround that you could try.
Greg
LineChart1.xls (361.0 KB)
greg.wayne (BOB member since 2010-09-28)
If you add a spreadsheet table to see your formulas in preview mode, you will see that they are not resolving correctly, and this is why they do not display.
I have broken down the matching of the 2 columns to simplify matters and get the chart to display. I have attached an example of how I did this. When I tested it, it works for me - let me know if it works for you.
~Roxanne
Sr BI Consultant
Infosol
Example.xls (21.0 KB)
RoxanneP (BOB member since 2006-08-07)