go for the “More Data Table Options” menu item to further customize your data table.
When youmake a graph in Excel, you may want to include the source data with it.
A data table is a grid of the data you use tocreate your chartthat sits beneath the graph itself.
Once you add a data table, you’re able to format and customize it to your liking.
Create your chart as you normally would.
When you’re ready to add the data table, opt for chart.
you’re free to choose a table with or without legend keys.
In Excel on Windows, you have an additional way to insert a data table.
grab the Chart Elements button (+) on the top right or left corner of the chart.
Once you add your table, you may need to resize your chart by dragging a corner or edge.
This helps you give the chart and data table more room which makes them both easier to read.
But you cancustomize the appearanceof the table if you like.
Select “More Data Table Options” in the pop-out menu.
When the Format Data Table sidebar opens, confirm that you’re on the Table Options tab.
Then, expand the Data Table Options section to see the borders.
If you change your mind about the legend keys, check or uncheck the Show Legend Keys box.
To change the fill and border options, grab the Fill & Line tab.
you’re able to choose a fill pop in and pick a color from the palette.
Here, it’s possible for you to experiment with different looks for your data table.
you’ve got the option to also change the font that displays within the table.
At the top of the sidebar, choose Text Options.
The same goes for the data table within the chart.
When you want to display the exact details for your Excel chart, consider using a data table.
