How do I get the data on a new tab (monthly expenses) to be added to a bar chart on a summary chart (YTD tab). Only the first 5 months of the year have a bar, June is not yet showing.
How do I get the data on a new tab (monthly expenses) to be added to a bar chart on a summary chart (YTD tab). Only the first 5 months of the year have a bar, June is not yet showing.
The following added the June data:
1. Put the cursor inside the chart and right click the mouse
2. Select "select data"
3. Select Add
4. Clear the Series Values window in the Edit Series dialog box
5. Select the underlined up arrow at the right end of the window
6. Select cells C8:C23 from the Jun 2024 sheet
7. Select OK
Note that I suggest using name that are more descriptive than series 2 etc. so that it is easier to keep up with which months are included.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks