Removing data point from the series without affecting whole series

Hello,
I need to remove the first column in Q1 series only from year 2020, but with keeping Q1 for other years. How can I do it? When I try to remove this single column it removes Q1 series from other years.
ss.JPG

So basically, I would like to have a graph with years on X axis, and then with:
Q2,Q3,Q4 values for 2020
Q1,Q2,Q3,Q4 values for 2021
Q1,Q2,Q3,Q4 values for 2022
Q1,Q2,Q3,Q4 values for 2023
Q1 value for 2024

I'm not sure I fully understand the question. Your sample file doesn't include a chart, nor any indication of where the data are coming from.

IMO, the "simple" solution to the question is to clear B3. I expect that there is more to how you are interacting with this sheet and how this table is populated so that "clear B3" is too simplistic of a solution. I expect that the final solution for the question will be to look at the process you are using to populate this table and how you are interacting with the spreadsheet, then change/adjust that process to prevent B3 from being populated or to clear B3 after it is populated.

Does that help?

Can you rearrange your data to look something like this:

Please Login or Register  to view this content.

I find that many charting questions end up being more about how one arranges the data in the spreadsheet.

Here is another alternate layout of data with quarters still having a unique colour.

If you don't want Qs in the axis replace all with a space.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.