As far as I know, most chart gurus think it is preferable If you can abandon the legend and be satisfied with data labels adjacent to each point, then create an XY chart with a single data series with many points and use the XY Chart Labeller to add the labels.
If you need to create such a chart with many data series, each with a single point, i.e., a chart with many legend items, or if you need to create many such charts, then you may want to automate the process using VBA. Maybe someone else has suggestions for making it "quick and easy." If you need to create such a chart with three single-point data series, the steps you described are appropriate. The data series name then appears in the chart legend. Your third post included steps for creating an XY chart with three data series, each with a single data point, so that the "label" is used as the name of the data series.
By default, the single series name appears in the chart title and in the legend. Your second post referenced a screen shot of Step 2 of the Excel 2003 chart wizard, showing an XY chart with a single data series with six data points.
(Your first post also referenced Excel 2003 "instructions" that are not applicable to an XY chart type, as far as I know.) So I suggested creating an XY chart with a single data series with three data pointsĪnd the XY Chart Labeller for attaching the label to each point. Your first post asked about creating an XY chart with "label." I interpreted "label" as an Excel data label, which is located adjacent to the data point on an XY chart.
0 kommentar(er)
