lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I created a chart of a data set called Newspapers. I have 4 data. I clicked on the chat and excel highlight the range for me in blue color with 4 boxes on sides so I can change the data set. So I used these 4 boxes - 2 at a time to not include month of Apr data or not including month of Jan data. My question, can I use this method (going to the chart dirctly) to include none conceqative data. For example data for month of Jan,Feb, Apr
It does not seem I can do it. I used CTRL, Alt, etc keys as well but did not help. Thanks a lot.
<tbody>
</tbody>
I created a chart of a data set called Newspapers. I have 4 data. I clicked on the chat and excel highlight the range for me in blue color with 4 boxes on sides so I can change the data set. So I used these 4 boxes - 2 at a time to not include month of Apr data or not including month of Jan data. My question, can I use this method (going to the chart dirctly) to include none conceqative data. For example data for month of Jan,Feb, Apr
It does not seem I can do it. I used CTRL, Alt, etc keys as well but did not help. Thanks a lot.
item | jan | mar | apr | may |
newspaper | 100 | 200 | 300 | 400 |
lottery | 100 | 333 | 444 | 555 |
drink | 223 | 333 | 543 | 987 |
<tbody>
</tbody>