✓ Board-verified
Accountancy · 2026 · 6 marks
Graphs and Charts for Business DataBasics Steps for Graphs/Charts/Diagrams Using Excel6 markslong answer
CBSE 2026 · Region 5 · Set 1 · Q34
'In MS Excel, charts can be formatted and customised to make them more attractive and meaningful.' Explain the procedure to change the shape style of a chart element. Also state various shape fill options available to the user for enhancing the appearance of a chart.
Marking-scheme solution
Changing the shape style on the format tab in the shape styles group do one of the following .
To see all available shape styles click the more button
To apply a pre-defined shape style, in the shape style box click the style that we want.
To apply different shape fill, click shape fill and then do one of the following.
To use a different fill colour, under theme colours or standard colours, left click the
select colour.
To remove the colour from the selected chart element click No Fill.
To use a fill colour that is not available under theme colours or standard colours
click more fill colours . In the colours dialog box, specify the colour that we want to
use on the standard or custom tab and then click OK. Custom fill colours are added
under Recent Colours can also be used.
To fill the shape with a picture, click picture. In the Insert Picture dialog box, click
the picture to use and then click Insert.
To use a gradient effect for the selected fill colour, click Gradient and then under
variations click the gradient style to be used. For additional gradient styles, click
more gradients and then in the fill category, click gradient option that to use
To use texture fill. Click texture.
More from Graphs and Charts for Business Data
- To see all available shape styles which of the following button is clicked. 'P2025
- From the following a legend can be repositioned on a chart: OR Which of the following are the five pillars of…2023
- A piece of information shown in a graph which is assigned to the data series is known as: OR Identify the…2025
- 'A piece of information shown in a graph which is assigned to the data series' is known as: OR 'LABELS in…2024
- Which chart element details the data values and categories below the chart:2026
- To see all available shape styles which of the following button is clicked?2025
- In a graph, the area bounded by different axes is known as:2025
- Write the advantages of using Graphs.2025
CBSE Class 12 Accountancy past-paper question from the 2026board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.