Microsoft Excel - horizontal (catagory) axis labels; EDIT Tab=Dimmed...how do I make it ACTIVE?

Excel 2007 I have noticed that the horizontal Axis options can change in an Excel 2007 chart, which is driving me crazy. On some charts when I open the horizontal axis options, under Axis options, they start out with "Interval between tick marks", "Interval between labels" and so on, which is what I expect to see. On another chart, with the

I have created a pivot chart that has two horizontal axis fields. The chart labels are too long to display properly and overlap each other. When I try to modify the axis labels, I can only modify one of the categories. How can I modify the other category labels? Excel Charting Discussions Chart (1) Excel (1) Axis (1) Hi, When using multi-level category

fields to line chart Microsoft Excel 28-Oct-12 07:59 PM I have nine horizontal axis labels from the data I'm calling for this chart, but excel is adding a tenth blank cells, line chart description: Excel adding blank fields to line chart I have nine horizontal axis labels from the data I'm calling for this chart, but excel is adding a tenth

Hi, I have a line graph where the vertical axis goes from -15 to 30. The horizontal labels then appear in the middle of the chart where the zero line is, how can I get the labels to be below the chart on the -15 line? I am using excel 2007. Thank You Stephen Excel Discussions Excel (1) Axis (1) Steve, This answer for Excel 2002, but I doubt it's changed in 2007. First right-click the Y axis, most easily done by right-clicking one of its labels. Select Format Axis. In the

I have a simple two-series line chart. At first I thought the horizontal axis labels just added unneccesary clutter. So I chose 'none' in one of the formatting dialogs, and they disappeared. Now I want to restore them. But I cannot 'select' the horizontal axis. When I click on it the entire plot area is selected. What are the exact

I have a surface contour polot and I wanted to change the axis labels, so I clicked Select Data Source and clicked edit under horizontal axis labels. I proceeded to type in a bunch of labels as = {0, 10, 20, . . }. I noticed that there was an error in one of the

POS Office 2007 I have a simple chart with 2 lines utilizing both the left and right vertical axis. The horizontal axis labels are wrapped nicely so that all fit, or so one thinks. When I print, the labels do not wrap, but overwrite each other. Even in print preview, the labels are all run together. Is there somewhere I can force a wrap of the labels

Hi, I have a small problem which I cannot seem to find a solution are waterfall charts, which I have constructed using a form of stacked bar chart. The labels for the horizontal axis are linked to text alongside the calculations for the charts. The text in the labels is of varying lengths and for some of the charts, this text is being wrapped on the label that appear on the chart. Every now and then, one of the labels is too long, and instead of wrapping to three layers (as I would expect it

Hi: For the x-axis (horizontal axis) how do I specify the tic-mark interval ? In other words, if the x-min 10 (or 25, or 50) how / where do I specify these values / lables for this axis? Thank you. . . DaleB Excel Charting Discussions Excel (1) DaleB (1) Horixontal (1) Lables (1) Axis (1) Min (1) Max (1) Tic (1) Hi, Assuming you are using a xy-scatter chart double click the X axis and on the scale tab set the Major Unit value. Cheers Andy - - Andy Pope, Microsoft www.andypope.info Hi: Thanx. . .but. . . What you suggest is only available for the y-axis (vertical axis). The horixontal (x) axis has less options: none allow you to specify the

The labels in my x-axis are text labels and some are rather lengthy. Is there a way to rotate the labels on the x-axis so they appear vertical instead of horizontal? SQL Server Reporting Services Discussions SQL Server (1) Legend (1) Axis (1) Ssas (1) Hi