![]() This data range corresponds to the Source Data – Data Range dialog below. If the X values are not drawn from the worksheet, there is no purple highlighted range. If the data range is defined in such a way that no series names are derived from the worksheet, there is no green highlighted range. The Y value data is highlighted by the blue outline, the X value data by the purple outline, and the series names by the green outline. Highlighting is used in Excel versions 97 (or earlier) through 2007 Excel 2003 was used for the illustrations in this post. ![]() If the data meets these conditions (elaborated upon later), selecting the chart area or the plot area of the chart will cause Excel to highlight the source data. The chart must be embedded in the worksheet that also contains the data. The source data range must be relatively simple, based on a rectangular data range. Excel highlights the data range of a chart under many conditions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |