Hi I will try to explain this as best as I possibly can. I have a huge table of Compensation Statement Data, Each Row data is entered for a new employee. In Column DN I am trying to insert a chart. I am selecting the series data by highlighting DB2 and DC2 hitting insert then bar graph, 100% Stacked bar. The information in DB2 is Total ER Paid Insurance Benefit and the information in DC2 is Total EE Paid Insurance Benefit. I can format the graph to fit in cell DN. When I copy the graph down (my data is entered until line 105) the Series data in the chart remains ='Benefit Data Sheet Edit'!$DB$2:$DC$2
If I edit the graph in DN2 series data to ='Benefit Data Sheet Edit'!DB2:DC2 and copy and paste down, the $$ come back.
Can I copy and paste this graph and have the data change to pull from the correct line? (aka next line down).
Bookmarks