Cyberdude
02-18-2010, 05:12 PM
I have a workbook with 16 charts on a single sheet that I’m trying to convert from Excel 2003 to Excel 2007. All charts are the XY type (scatter point??) that have two vertical axes i.e., there are two independent sets of data on one chart sharing a common horizontal axis. The horizontal axis is displayed at the top of the chart.
My problem is that I have to change the color of the data values on the horizontal axis, and I can’t figure out how to do it. I had no trouble changing the color on the vertical axes by right clicking on the axis and using the font option in the dialog box to specify a different color. Not so with the horizontal axis. There must be at least 3 maybe 4 different dialog boxes I could call up, and none of them (with one exception) had any effect on the horizontal axis.
To call up a “format axis” dialog box I would position the cursor very close to the common edge of the H axis and the plotting area, but somewhere in the axis data area. Curiously there is one of the 16 charts that responds to this technique and performs the color change that I need. Since I usually have the data for the H axis at the top of the plotting area, I moved it to the bottom, but it didn’t work.
Oddly, by moving the cursor just a small distance horizontally from one click position to another, I will trigger a dialog box that changes ALL text box areas in the plotting area. It has no indication that it will do that.
Anyone know what I’m doing wrong?
Sid
My problem is that I have to change the color of the data values on the horizontal axis, and I can’t figure out how to do it. I had no trouble changing the color on the vertical axes by right clicking on the axis and using the font option in the dialog box to specify a different color. Not so with the horizontal axis. There must be at least 3 maybe 4 different dialog boxes I could call up, and none of them (with one exception) had any effect on the horizontal axis.
To call up a “format axis” dialog box I would position the cursor very close to the common edge of the H axis and the plotting area, but somewhere in the axis data area. Curiously there is one of the 16 charts that responds to this technique and performs the color change that I need. Since I usually have the data for the H axis at the top of the plotting area, I moved it to the bottom, but it didn’t work.
Oddly, by moving the cursor just a small distance horizontally from one click position to another, I will trigger a dialog box that changes ALL text box areas in the plotting area. It has no indication that it will do that.
Anyone know what I’m doing wrong?
Sid