Results 1 to 2 of 2
Thread: Line chart (2000 SP-3)
2004-08-11, 13:38 #1
- Join Date
- Jun 2001
- Thanked 0 Times in 0 Posts
Line chart (2000 SP-3)
I'm trying to create a line chart but it doesn't come out anywhere near what I need. I walked through the wizard and came up with the attached file. The general layout is good but there are still these problems:
-- Not all employees are showing (the horizontal axis).
-- The data looks compressed. I'd like the chart a lot larger but I can't change it in the Design view.
-- I can't fix the legend names. Right now, they are the field names from the table--I'd like something more descriptive.
2004-08-11, 13:56 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Line chart (2000 SP-3)
Double click the chart in design view. You probably won't see the actual data, but you will be able to change the size of the chart area. It's best to select Format | Selected Chart Area before resizing, and clear the Auto Scale check box in the Font tab. If you make the chart area wider, all employee names should be displayed.
To fix the legend, you will probably have to provide aliases for the field names in the query that acts as data source for the chart.