• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Selecting a Chart with No Background or Borders

Q1: Excel won't let me select a chart after I set the background and borders to none.
A1: Use the Select Objects button on the Drawing toolbar to select the chart.

Aligning a Chart to the Grid on a Worksheet

Q1: Is there a way to align a chart with the grid of the worksheet?
A1: It's a bit tricky. Align the chart as best you can to the grid. Then select the columns that span over the range of columns and chart, resize the columns to a larger size, and then resize them back to the smaller size. The chart bars now should align pretty closely.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint