在Excel中更改默认图表类型

On July 25th I announced a giveaway for Jon Peltier’s amazing Chart Utility, and thanks for all the entries! The deadline was yesterday, August 5th, at 12 noon Eastern time, and the winner of the random draw is:

7月25日，我宣布了Jon Peltier惊人的Chart Utility的赠品 ，并感谢所有参赛作品！ 截止日期为东部时间8月5日，昨天，中午12点，随机抽奖的获胜者为：

• Krystal, who posted comment #11.

  克里斯塔尔(Krystal ) 发表了第11条评论 。

Congratulations, and Jon will send you an email to arrange the delivery of your Chart Utility. You’ll have 24 hours to reply to his email.

恭喜，Jon会给您发送电子邮件，以安排您发送Chart Utility。 您将有24小时回复他的电子邮件。

更改默认图表类型 (Change the Default Chart Type)

And now, here is a chart tip, for those times when you’re creating a simple chart.

现在，这是一个图表提示，适用于创建简单图表的那些时间。

When you first install Excel, the default chart type is a clustered column. If you select data and press the F11 key, that’s the type of chart that will be created.

首次安装Excel时，默认图表类型为群集列。 如果选择数据并按F11键，则将创建图表。

If you’d like a different chart type as the default, you can easily change it. Here are the steps in Excel 2013:

如果您希望使用其他图表类型作为默认图表类型，则可以轻松进行更改。 以下是Excel 2013中的步骤：

• On the Ribbon’s Insert tab, click the See All Charts button, at the bottom right of the Charts group.
  在功能区的“插入”选项卡上，单击“图表”组右下方的“查看所有图表”按钮。

• Click the All Charts tab, and click one of the chart categories, such as Line.
  单击所有图表选项卡，然后单击图表类别之一，例如折线。
• Right-click one of the chart sub-types, such as Line, and click on Set As Default Chart
  右键单击图表子类型之一，例如“折线”，然后单击“设置为默认图表”

• Click Cancel, to close the Insert Chart window.
  单击“取消”，关闭“插入图表”窗口。

In Excel 2010, the steps are almost the same – just click the Set as Default Chart button after you select a chart sub-type.

在Excel 2010中，步骤几乎相同–选择图表子类型后，只需单击“设为默认图表”按钮。

观看视频 (Watch the Video)

To see the steps for creating a quick chart, and changing the default chart type in Excel 2010, watch this short video.

若要查看在Excel 2010中创建快速图表以及更改默认图表类型的步骤，请观看此简短视频。

演示地址

翻译自: https://contexturesblog.com/archives/2013/08/06/change-the-default-chart-type-in-excel/