Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Mon 12 May 2008, 16:58 Delegate Jonathan said...

Jonathan has attended:
Excel Introduction course

Excel

When a chart is created can one change the axis or are they determined by the horizontal and vertical rows/columns of the spreadsheet. What is the default, i.e. the vertical/left hand column creates which axis? Many thanks.

Jonathan

Sun 18 May 2008, 18:14 Trainer Alan said...

RE: Excel

Hi Jonathan

Click on the chart and then go to the dropdown on the chart toolbar. Choose the Axis you want to change and edit it!

You could also point directly at the axis, right click and choose the FORMAT AXIS option from the shortcut menu.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Display pictures on Chart Data Point