How To Change A Chart Style In Excel

Formatting Charts in Excel

One time you create a nautical chart it'due south easy to format and enhance your nautical chart using Excel's menus and commands. To change chart mode in Excel, simply right click or double click on the chart item you want to format to view the formatting options for that detail.

Just a few of the chart items you can format are:

• Chart Titles, Axis Titles, and Data Labels
• Chart Lines
• Axis Labels
• Plot Area / Chart Area

Chart Titles, Axis Titles, and Data Labels

TO Alter TEXT: To change the title, axis or data label text, click once on the text box to highlight it, then click once again to place your cursor inside the text box. Notation: don't double click on the title; this will open the formatting box and text cannot be modified at that place.

TO CHANGE TITLE APPEARANCE: Right click on the title or data label you want to format and select Format, or double click.

Chart Title:

Axis Championship:

Data Label:

From the formatting window you tin can change text box color and patterns, font style, and text box alignment:

Chart Lines

To change the colour or style of chart lines, merely click on the line to highlight information technology, then right click to view the formatting options, or double click on the line:

From the Format Data Series window you can select line colors and styles and show or hide data labels:

Axis Labels

Right click the centrality labels you want to format and select Format Centrality, or double click:

From the formatting window, you can change label fonts, number formats, label alignment, and axis calibration (e.g. change minimum and maximum values on y axis):

Plot Area / Chart Area

If you are using QI Macros charts in a presentation, you may want to add some color. You may add a groundwork colour to the chart past right clicking in a blank area inside the chart and selecting Format Plot Area:

You may also add a background colour to thenautical chartarea (the area surrounding your chart) by right clicking in a blank areaoutsideof the chart and selecting Format Nautical chart Area:

From the Format Plot Expanse or Format Chart Area window, yous can select a background colour for the chart, nautical chart borders, and fill effects:

Excel 2007 Formatting Tips

With Microsoft'due south release of Excel 2007, many of the menus have inverse.

Additionally, when formatting charts in Excel, you must right click on the item to open up the formatting window, or left click once to highlight the item, and so select your formatting options from the Home tab on the Excel 2007 Ribbon:

Double clicking on a chart detail in Excel 2007 does not open the formatting window every bit in previous versions of Excel.

• Formatting Nautical chart Titles, Axis Titles, and Information Labels
• Formatting Nautical chart Lines
• Formatting Axis Labels
• Formatting Plot Surface area / Chart Area

Formatting Chart Titles, Axis Titles, and Data Labels

Right click on the championship and a formatting window and pull downward menu will open up:

Notice that you may also select Edit Text:

Click on Format Chart Championship to open this Menu:

Formatting Chart Lines

Right click on the line and select Format Data Series:

From the Format Data Series window y'all can select line colors and styles:

Formatting Axis Labels

Right click on the Axis and select Format Axis from the pull down menu or use the options in the formatting window:

The Format Centrality window looks like this:

Formatting Plot Area / Chart Surface area

You may add a background color to the chart by right clicking in a blank area within the chart and selecting Format Plot Surface area:

You may also add together a background colour to thenautical chartarea (the area surrounding your chart) by right clicking in a blank surface areaoutsideof the chart and selecting Format Nautical chart Area:

From the Format Plot Area or Format Nautical chart Area window, you tin select a groundwork color for the nautical chart, chart borders, shadows and 3D effects:

As you lot can see, once you run a chart with QI Macros, you can employ whatever of Excel's nautical chart formatting options.

Learn More...

• Customize QI Macros Templates
• Tips for Using the SPC Chart Templates for Excel in QI Macros
• Command Chart Templates in Excel

Other Charts Included in QI Macros for Excel

Source: https://www.qimacros.com/free-excel-tips/format-charts/

Posted by: ortizfoophy.blogspot.com

Share this post