txcwboy

Thanks for the advice. I will try this out, let you know and mark your post accordingly (if it was the answer).

I've got a bit of a problem and hopefully I can explain so that all will understand. I have a crosstab chart that is displaying the celsius temperature over time per temperature probe. What I want to be able to do is display not only the celsius temperature in the tooltip, but its fahrenheit equivalent. Thereby negating having to create a duplicate of every one of my temperature charts just to show fahrenheit. Is there anyway to reference a second data series (value) in a crosstab chart to pull the correlating fahrenheit temperature or a way to calculate the fahrenheit and have that displayed in the tooltip? Thanks.