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 : Changing the Chart Background & Enhancing a Chart

7/3/2011 4:56:01 PM

Changing the Chart Background

Format the background of a chart by showing or hiding the chart wall or floor with a default color fill, or by changing the 3-D view of a chart. The plot area is bounded by the axes, which includes all data series. The chart wall is the background, and the chart floor is the bottom in a 3-D chart. The 3-D view allows you to change the rotation of a 3-D chart using the x-, y-, or z-axis, and apply a 3-D perspective to the chart.

Change the Chart Background

Select the chart element you want to modify.

Click the Layout tab under Chart Tools.

Click any of the following buttons:

  • Plot Area to show or hide the plot area.

  • Chart Wall to show or hide the chart wall with the default color fill.

  • Chart Floor to show or hide the chart floor with the default color fill.

  • 3-D Rotation to change the 3-D viewpoint of the chart.

    In the Format Chart Area dialog box, click 3-D Rotation or 3-D Format in the left pane, select the 3-D options you want, and then click Close.




Enhancing a Chart

If you want to further enhance a chart, you can insert a picture, shape or text annotation to add visual appeal. In the same way you insert a picture, shape, or text box into a worksheet, you can insert them into a chart. The Picture, Shapes, and Text Box button are available on the Layout tab under Chart Tools.

Insert a Picture, Shape, or Text

Select the chart element you want to modify.

Click the Layout tab under Chart Tools.

Use any of the following:

  • Picture. Click the Picture button, select a picture, and then click Insert.

  • Shapes. Click the Shapes button, click a shape, and then drag to draw the shape.

  • Text Box. Click the Text Box button, drag to create a text box, and then type the text you want.


Use the Format tab under Drawing Tools to format the shape or text box.



You can edit shape text. Right-click the shape or text object, click Edit Text, modify the text, and then click outside the object to deselect it.

You can convert a chart to a picture. Select the chart, click the Home tab, click the Copy button, click the Paste button arrow, point to As Picture, and then click Paste As Picture. Instead of using Paste As Picture, you can use Paste Special to paste a chart as a picture with a specific graphic format, such as PNG, JPEG, GIF, Enhanced Metafile, or Bitmap.

Other -----------------
- Microsoft Excel 2010 : Formatting Chart Text & Formatting Line and Bar Charts
- 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
 
 
Top 10 video Game
-   Unravel | Live Gameplay from E3 2015
-   Destiny: Xur, Agent of the Nine, Reef location and exotic items
-   Metal Gear Solid 5: The Phantom Pain | E3 2015 Stage Demo
-   OVERKILL's The Walking Dead | The VR Experience Trailer
-   Batman: Arkham Knight | NVIDIA GameWorks Gameplay Video
-   World of Warcraft: Warlords of Draenor | Patch 6.2 – Fury of Hellfire
-   Call of Duty: Black Ops III | Cyber Core Tutorial and Co-Op Playthrough
-   Back to Bed - E3 2015 Trailer
-   Whispering Willows - E3 2015 Trailer
-   Velocibox - E3 2015 Trailer
-   Anno 2025 - E3 2015 Gameplay Trailer
-   Anno 2025 - E3 2015 Intro Trailer
-   Awesome GTA V Sniper Chopper Kill
-   Awesome GTA V Parachute Video
-   GTA V Explosive Ammo Rounds with Bikini
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
MineCraft
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer