How would I go about updating the series on a chart that is currently setup like this to utilize a table?
Series Name: =Harrisburg!$H$6
Series Values: =Harrisburg!$H$7:$H$146
The table is already setup and when I create a new chart from that table the data series information looks the same. Am I missing something here?
Series Name: =Harrisburg!$H$6
Series Values: =Harrisburg!$H$7:$H$146
The table is already setup and when I create a new chart from that table the data series information looks the same. Am I missing something here?