(Windows 7 ENT, Excel 2016)
I have data in a helper table at AB57:AE60. (4x4) for charting in a workbook.
The columns are:
"Which Data", 2015, 2016, 2017
The rows are:
Data 01, Data 02, Data 03
Referencing a drop-down list located at AB2, If AB58:AB60=AB2, express the appropriate row of information, with the year as a title with the data above the graphical representation.
When I use a single year and make the chart not selectable from the drop-down, I am successfully using:
="<data type=""> Totals: 2015 - "&$AC$58&" | 2016 - "&$AD$58&" | 2017 - "&$AE$58&""
I am hoping to find an easy way to get the following result:
<data type=""> Totals: 2015 - <###> | 2016 - <###> | 2017 - <###>
When I try to create a conditional so that there is a comparison between AB2 (selected by the drop-down) and the series AB58:AB60, I am running into the issue where Excel is asking if I'm not trying to type a formula.
I have used variations of these two:
=$AB$58:$AB$60,$AB$2,"&$AB$58:$AB$60&Totals:""&$AC57 -""&$AC$58:$AC60&""&$AD$57 -""&$AD$58:$AD$60&""&$AE$57 -""&$AE$58:$AE$60&"
and
=IF($AB$58:$AB$60,$AB$2,"&$AB$58:$AB$60&Totals:""&$AC57 -""&$AC$58:$AC60&""&$AD$57 -""&$AD$58:$AD$60&""&$AE$57 -""&$AE$58:$AE$60&")
But I do not look forward to creating titles for multiple charts in this workbook if nested IF or other verbose methods are called for.
The data is substantial but the data type and yearly totals are used as a title across the chart of numerous data points. I have to have titles and my manager would like the titles to be as flexible as the drop-down in AB2 for displaying the three difference sets of data.
Suggestions?</data></data>
I have data in a helper table at AB57:AE60. (4x4) for charting in a workbook.
The columns are:
"Which Data", 2015, 2016, 2017
The rows are:
Data 01, Data 02, Data 03
Referencing a drop-down list located at AB2, If AB58:AB60=AB2, express the appropriate row of information, with the year as a title with the data above the graphical representation.
When I use a single year and make the chart not selectable from the drop-down, I am successfully using:
="<data type=""> Totals: 2015 - "&$AC$58&" | 2016 - "&$AD$58&" | 2017 - "&$AE$58&""
I am hoping to find an easy way to get the following result:
<data type=""> Totals: 2015 - <###> | 2016 - <###> | 2017 - <###>
When I try to create a conditional so that there is a comparison between AB2 (selected by the drop-down) and the series AB58:AB60, I am running into the issue where Excel is asking if I'm not trying to type a formula.
I have used variations of these two:
=$AB$58:$AB$60,$AB$2,"&$AB$58:$AB$60&Totals:""&$AC57 -""&$AC$58:$AC60&""&$AD$57 -""&$AD$58:$AD$60&""&$AE$57 -""&$AE$58:$AE$60&"
and
=IF($AB$58:$AB$60,$AB$2,"&$AB$58:$AB$60&Totals:""&$AC57 -""&$AC$58:$AC60&""&$AD$57 -""&$AD$58:$AD$60&""&$AE$57 -""&$AE$58:$AE$60&")
But I do not look forward to creating titles for multiple charts in this workbook if nested IF or other verbose methods are called for.
The data is substantial but the data type and yearly totals are used as a title across the chart of numerous data points. I have to have titles and my manager would like the titles to be as flexible as the drop-down in AB2 for displaying the three difference sets of data.
Suggestions?</data></data>