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

Troubleshooting

Moving Category Labels

Q1:Excel won't let me place my category labels in a different location.
A1: You can move the X-axis on a column chart to the top of the chart. Select the axis and choose Format, Selected Axis to open the Format Axis dialog box. On the Patterns tab, choose High under Tick Mark Labels.

Invisible Data Series

Q1:When I create a secondary axis for the second data series of my column chart, the columns are hidden behind the first data set.
A1: Select the data series in front of the other data series, and choose Format, Selected Data Series to open the Format Data Series dialog box. On the Patterns tab, choose None under Area.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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