This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I need to create a Product Sales by Region for each product. So I will first create a chart with column A and B for Product A. Then I will hide column B, and then select column A and C to create the chart for Product B. Then I will hide column C, and then select column A and D (Column B is still hidden) to create the chart for Product C.
Is there a quicker way to do it?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Make a single chart with all the data.
Format this to suit your needs
Make 3 copies of the chart
In chart 1, delete products B, C, D
In chart 2 delete products A, C, D
etc
You do know about filtering in a chart? - see screen capture
best wishes
Thank you very much.
Both methods work.