Table of contents
- Getting Started
- Getting Help
-
Shortcut Keys
- Use shortcut keys in Microsoft Graph
- Keys for moving around on a datasheet
- Select cells or chart items by using shortcut keys
- Enter and edit data by using shortcut keys
- Format data by using shortcut keys
- Work in dialog boxes by using shortcut keys
- Work with windows, programs, and Help by using shortcut keys
- Work with menus and commands by using shortcut keys
- Work with drawing objects and text boxes on charts by using shortcut keys
- Keys for working with Help
- Keys for using the Office Assistant
-
Using Data from Other Programs
- Use data from another program in your chart
- File formats Microsoft Graph can import
- Copy data from another application
- Link to data in another program to create a chart
- Break a link to data in another program
- Import a Microsoft Excel worksheet or chart
- Import a text file or Lotus 1-2-3 file to create a chart
- How Microsoft Graph interprets Lotus 1-2-3 number formats
- Chart Types
-
Adding and Changing Text and Data in a Chart
- Enter data on a datasheet
- Add or remove data from a chart
- Add a text box to a chart
- Change category axis labels, data series names, or legend text
- Change chart labels, titles, and other text
- Edit chart and axis titles
- Align text in chart titles and text boxes
- Change data labels
- Change values in a chart
- Change the way data is plotted
- Change the points plotted in a pie-of-pie or bar-of-pie chart
- Change values in a 2-D chart by dragging data markers
- Change which row or column contains the x axis values for an xy (scatter) chart
- Control the way empty cells are plotted
- Exclude or include rows or columns of a datasheet from a chart
- Plot data series from datasheet rows instead of columns, and vice versa
- Reverse the plotting order of categories, values, or series
- Plot a data series along a secondary value axis in a 2-D chart
-
Troubleshooting Text and Data
- Where did the data for my chart go?
- I typed new text or numbers on the datasheet, but the data labels in the chart didn't update.
- Text is missing along the horizontal axis of the chart.
- The text box, picture, or floating text I added to my user-defined chart type is not included when I create a chart.
- Why does the font size in my chart keep changing?
-
Changing Chart Display Options
- Add a legend to a chart
- Add a title to a chart or axis
- Add data labels to a chart
- Change the display of chart labels, data tables, legends, gridlines, or axes
- Delete data labels, titles, or legends in a chart
- Display or hide a data table in a chart
- Display or hide axes in a chart
- Display or hide gridlines in a chart
- Display or hide information about chart items
- Using dates in charts
- Troubleshooting Display Options
- Formatting Data Markers, Labels, and Other Chart Items
-
Using Error Bars and Trendlines
- Trendlines in charts
- Choosing the best trendline for your data
- Add a trendline to a data series
- Change trendline settings
- Display the R-squared value for a trendline
- Delete a trendline
- Equations for calculating trendlines
- Error bars in charts
- Add error bars to a data series
- Change error bar settings
- Delete error bars
- Equations for calculating the error amount
-
Working on a Datasheet
- Move and scroll through a datasheet
- Undo mistakes
-
Working with Datasheet Cells
- Delete cells, rows, or columns on a datasheet
- Insert blank cells, rows, or columns on a datasheet
- Clear cells, rows, or columns on a datasheet
- Move or copy part of a cell's contents into another cell
- Move or copy cell data
- Change column width on a datasheet
- Change the font on a datasheet
- Select cells, ranges, rows, and columns on a datasheet
- Restore datasheet columns to the default width
- Move or copy entire cells
-
Working with Number Formats
- Create custom number formats
- Change the way Microsoft Graph displays numbers, dates, and times
- About custom number, date, and time format codes
- Basic number format codes
- Formats for dates and times
- Formats for text and spacing
- Delete custom number formats
- Change the number format of datasheet cells or chart items
- Number, date, and time format codes
- Formats for percentages, exponential notation, and non-U.S. currency
- Working with AutoCorrect
- Troubleshooting the Datasheet
- Customizing Toolbars and Menus
- Editing Chart Data
-
Working with Drawing Objects and Graphics
- About graphic objects in Microsoft Graph
- About drawing freeforms and curves
- Show or hide the Drawing toolbar
- Symbols used in drawing object manipulation
-
Inserting Objects
- Insert a graphic object
- Insert an imported picture in a chart
- Add a circle, square, or other AutoShape
- Add a curve
- Add a freeform object
- Add a line
- Add a WordArt drawing object
- Add or change the 3-D effect of a drawing object
- Add or edit a WordArt drawing object
- Add or move a connector line
- Add text to an AutoShape or text box
-
Changing and Resizing Objects
- Change the AutoShape type
- Change the shape of a freeform or curve
- Change the appearance of text in an AutoShape or text box
- Change the margins around text in an AutoShape or text box
- Change the text in a WordArt drawing object
- Make an AutoShape or text box automatically fit its text
- Edit a picture
- Move a drawing object or set of objects
- Move a text box
- About resizing or cropping an object
- Resize an object
- Resize an object by a specific percentage
- Crop or trim portions of a picture
- Maintain the proportions of an object while resizing it
- Restore a picture to its original size
- Rotate a drawing object to any angle
- Rotate a drawing object 90 degrees to the left or right
- Flip a drawing object horizontally or vertically
- Reroute a connector line
- Save a drawing object style as the default
- Delete an AutoShape or graphic object
-
Aligning, Arranging, and Grouping Graphics
- About grouping drawing objects
- Align drawing objects on a grid
- Group drawing objects
- Move, or
- Ungroup and change clip art
- Regroup drawing objects
- Stack drawing objects
- Ungroup drawing objects
- Align text in an AutoShape or text box
- Set margins and align text that is attached to an AutoShape or text box
-
Working with Borders, Fills, Lines, Shadows, and 3-D Effects
- Change the style of a drawing object line or border
- Change the color of a line or border around a drawing object
- Make a dashed line or border around a drawing object
- Add or change a gradient (shaded), patterned, textured, or picture fill in a drawing object
- Change a fill color in a drawing object
- Add, change, or remove a fill in a drawing object
- Remove a fill in a drawing object
- Add a shadow or 3-D effect to a drawing object
- Add a shadow to a drawing object
- Change the color of a shadow on a drawing object
- Change the offset direction of a shadow on a drawing object
- Remove a shadow from a drawing object
- Change the color of the 3-D effect of a drawing object
- Remove a 3-D effect from a drawing object
- Troubleshooting Drawing Objects
- Troubleshooting