Ok, got it to work. I had some blanks in the time series data that prevented
that button from coming up. After I eliminated the blanks when I clicked on
the button Excel would crash though. This was very repeatable. But I was
encouraged that this was the answer so I deleted all my pivot tables and
recreated them. After doing this, the formatting from the raw data actually
came through on the chart so I didn't have to use the button anyhow. I guess
the blanks polluted something that prevented this from working.

thanks!