I am creating graph and conditional formatting from simple sales data. Instead of doing all manually, I will check the Copilot integrated into Excel first.

When working with Copilot, activate the autosave. I saved the file in OneDrive.

This picture was taken in the top left corner.

I created simple sales data.

The copilot is in the top right corner in data.

Additionally, Copilot icon can be found in the home ribbon.

I activated the data range and selected the Copilot and “Ask Copilot”.

Copilot menu appeared on the right. I pressed apply color and formatting.

I wrote in the chat box “Highlight cells with highest values.”.

I pressed apply.

The result, the highest value is coloured.

I wrote “show data insights”.

I pressed add to a new sheet.

Here is the graph.

This graph visualizes the sales volumes between different products. P5 and P2 have clearly the highest volumes.

I wrote “create a pie chart” in Copilot chat box.

The results. I added to a new sheet.

This is what Copilot created. The graph can still be modified like header can be changed to a more descriptive and the legend could be printed with bigger font.

Double click the header and re-write the header.

Select the right mouse button on top of the legend and select font.

There are many ways you can test Copilot. I just took some examples when creating a graph and conditional formatting. If results from Copilot are not fully completed, you can always start the work with Copilot and finetune the task manually. That might save time.