I was sent a spreadsheet with a couple graphs on it that I'm supposed to update. I put in the necessary information to update the spreadsheets just fine, but I obviously had to go in and select the added information to show in the graph. I then clicked Select Data, Add (Legend Entries). It opens up with three different areas to fill in (Series name, Series X values, Series Y values). However, if I go in to edit the information, some have the three fields to fill in while others only have two (Series name, Series values). The data for the chart comes from two different spreadsheet tabs.
If you need more information, please let me know. I'm not sure where to go or what to do to fix this problem.
Thank you!
Bookmarks