Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Excel 2010 : Formatting Chart Text & Formatting Line and Bar Charts

7/2/2011 4:43:16 PM

Formatting Chart Text

Objects such as chart and axis titles, data labels, and annotated text are referred to as chart text. To make chart text more readable, you can use formatting tools on the Home or Format tabs to change the text font, style, and size. For example, you might decide to change your chart title size and alignment, or change your axis text color. If you want to change the way text appears, you can also rotate text to a diagonal angle or vertical orientation. On the Format tab under Chart Tools, you can apply WordArt and Shape Styles to chart text.

Format Chart Text

Select the chart that contains the text you want to change.

Select the text object in the chart you want to format.

If you want to select only a portion of the text, click the text object again to place the insertion point, and then select the part of the text you want to format.

Click the Format tab under Chart Tools, and then click the WordArt or Shape Style you want.

Click the Home tab.

In the Font group, select any combination of options: Font, Font Size, Increase Font Size, Decrease Font Size, Bold, Italic, Underline, Fill Color, or Font Color.

In the Alignment group, select any combination of alignment options.

Timesaver

To quickly format chart text, right-click the text, and then click a formatting button on the Mini-Toolbar.

To set custom text formatting options, click the Font or Alignment Dialog Box Launcher.




Formatting Line and Bar Charts

If you’re using a line or bar chart, you can add trendlines, series lines, drop lines, high-low lines, up/down bars, or error bars with different options to make the chart easier to read. Trendlines are graphical representations of trends in data that you can use to analyze problems of prediction. For example, you can add a trendline to forecast a trend toward rising revenue. Series lines connect data series in 2-D stacked bar and column charts. Drop lines extend a data point to a category in a line or area chart, which makes it easy to see where data markers begin and end. High-low lines display the highest to the lowest value in each category in 2-D charts. Stock charts are examples of high-low lines and up/down bars. Error bars show potential error amounts graphically relative to each data marker in a data series. Error bars are usually used in statistical or scientific data.

Format Line and Bar Charts

Select the line or bar chart you want to modify.

Click the Layout tab under Chart Tools.

In the Analysis group, click any of the following:

  • Trendline to remove or add different types of trendlines: Linear, Exponential, Linear Forecast, and Two Period Moving Average.

  • Lines to hide Drop Lines, High-Low Lines or Series Lines, or show series lines on a 2-D stacked Bar/Column Pie or Pie or Bar of Pie chart.

  • Up/Down Bars to hide Up/Down Bars, or show Up/Down Bars on a line chart.

  • Error Bars to hide error bars or show error bars with using Standard Error, Percentage, or Standard Deviation.


Other -----------------
- Visual Studio 2010 : Building the Windows Container (part 3) - Creating a Multiple Document Interface
- Visual Studio 2010 : Building the Windows Container (part 2) - Adding menus and toolbars
- Visual Studio 2010 : Building the Windows Container (part 1) - Setting common form properties & Creating dialog boxes
- Microsoft Visio 2010 : Adding Labels to Flowcharts & Understanding Swimlane Diagrams
- Microsoft Visio 2010 : Selecting a Flowchart Type & Creating Flowcharts
- Automating the Windows 7 Installation : Choosing Automated Deployment Options (part 3) - An Overview of the System Preparation Tool and Disk Imaging
- Automating the Windows 7 Installation : Choosing Automated Deployment Options (part 2)
- Automating the Windows 7 Installation : Choosing Automated Deployment Options (part 1) - An Overview of the Microsoft Deployment Toolkit 2010
- Advanced .NET Framework with VB 2010 : Coding Attributes - Reflecting Attributes
- Advanced .NET Framework with VB 2010 : Coding Attributes - Coding Custom Attributes
 
 
Top 10 video Game
-   Minecraft Mods - MAD PACK #10 'NETHER DOOM!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #9 'KING SLIME!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #2 'LAVA LOBBERS!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #3 'OBSIDIAN LONGSWORD!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Total War: Warhammer [PC] Demigryph Trailer
-   Minecraft | MINIONS MOVIE MOD! (Despicable Me, Minions Movie)
-   Minecraft | Crazy Craft 3.0 - Ep 3! "TITANS ATTACK"
-   Minecraft | Crazy Craft 3.0 - Ep 2! "THIEVING FROM THE CRAZIES"
-   Minecraft | MORPH HIDE AND SEEK - Minions Despicable Me Mod
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 92 "IS JOE DEAD?!"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 93 "JEDI STRIKE BACK"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 94 "TATOOINE PLANET DESTRUCTION"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 95 "TATOOINE CAPTIVES"
-   Hitman [PS4/XOne/PC] Alpha Gameplay Trailer
-   Satellite Reign [PC] Release Date Trailer
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
programming4us programming4us
PS4 game trailer XBox One game trailer
WiiU game trailer 3ds game trailer
Trailer game
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer