In this commodity, nosotros are going to see how to Save And Use An Excel Chart Template In Excel 365.Allow's go into this article!! Become an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Leap To:

  • Create a Chart Template
  • Create secondary centrality
  • Format the chart
  • Save the custom chart equally Template
  • Utilize the Saved Chart Template
  • Verdict

Create a Chart Template

  • Firstly, yous have to enter the information in the Excel worksheet.
  • Here, we take created a sample prize details for month wise.
Sample prize details
  • Now, y'all need to select this data, and go to insert tab and insert a chart of your choice.
Select the chart blazon

Create secondary axis

  • You need to right-click on the chart and click on the change chart blazon option.
Click on alter series chart type
  • Then, yous have to click on thephilharmonic chart type.
Click on Philharmonic nautical chart type
  • Now, you lot need to click on secondary axis bank check box for indicate series.
  • After that, you accept to alter the chart blazon for signal series to line with markers.
Click the secondary axis
  • Finally, you need to Hit the OK button.
Click OK push button

Format the chart

  • You need to double-click on the chart and go to the format pick and choose colour choice of yours.
Choose the color
  • Then, you have to add the chart championship as "prize details" and remove the filigree lines.
Add together the championship
  • Now, you need to increase the width of the columns by reducing the gap width betwixt them and the information labels for both series.

Salve the custom chart every bit Template

  • Yous demand to correct-click on the chart and click on the Salve as Template selection.
Click on Relieve as Template
  • Then, you accept to name and salvage the chart template at desired location.
Name the Template
  • For that, the to a higher place step will open a save equally dialog box and the relieve filter is gear up to Chart Template File.
  • Now, the extension of a chart template is .crtx which you don't need to mention.
  • After that, the default location of chart templates is Microsoft/Templates/charts, and you lot tin change if you want.
  • Finally, you have to click on the Salvage push.

Use the Saved Chart Template

  • Firstly, yous accept to select the information and go to the Insert tab.
  • Then, y'all need to click on the Recommended Charts under the Charts section.
Click on Recommended chart
  • At present, Excel volition testify some recommended charts for your data.
  • After that, you have to ignore them and switch to All Chart Tab.
  • Hither on the pinnacle, you will see a binder named templates and click on it.
  • Y'all need to select the chart and striking OK button, and you lot have your custom chart gear up.
  • At final, you lot accept to set up the name of the nautical chart and accommodate the size of chart.

Verdict

In this short tutorial, we take described how to Salvage And Use An Excel Chart Template In Excel 365. Clear-cut screenshots assist you to employ the tool fifty-fifty simpler. Is this article helpful? Don't forget to share your valuable queries/feedback in the below comment box. Thank you for visiting Geek Excel!! Keep Learning!!

Keep Reading:

Rate our Tutorial