Forum Discussion
Emmarky
Jan 01, 2024Copper Contributor
Line chart
Hi, Taking this table as an input, how to create a similar line chart and also a bar chart in Excel.if you could let me know the process that would be great as I can also learn from that.Thanks in Ad...
HansVogelaar
Jan 01, 2024MVP
Since you want the different cache sizes to be separate chart series, you need to layout the data differently, with a column for each cache size:
You can then create a line chart and bar chart (or column chart) from this range.
By default, Excel will treat Block Size as a series. To correct that, click on the chart, then click Select Data on the Chart Design tab of the ribbon.
Select Block Size, then click Edit.
Select the Series values range, and copy it (Ctrl+C).
Click Cancel, then click Remove.
Next, click Edit under Horizontal (Category) Axis Labels.
Clear the box, then paste (Ctrl+V).
Click OK to confirm.
See the attached demo.
Click OK, then select