Excel x,y chart type x range must be re-entered each series



In Excel x,y type charts, the x range must be re-entered for each series if
the data range is beyond the complexity supported. Please consider a
sub-type for graphs where all of the x ranges are the same. Also, consider
making the data range feature have options for using the top or left row for
series names, and the left or top row for the x range. Even better, allow
multiple rows or columns at top or left for series names.

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.




Jon Peltier

In a line, column, or area chart, the set of X values for the first series
is used for subsequent series (even if you specifically identify unique X
values for them). If it's an XY chart, consider copying what's in the X
values input box, so you can paste it into the box for the next series.

To use the top row for series names and the left column for X values, leave
the top left cell blank. This tells Excel that the top row and left column
are different from the rest of the data range. To use the top two rows for
series names, leave the top two cells of the left column blank. In fact,
leave blank the cells at the intersection of the top several rows you're
using for series names with the left several columns you're using for
category labels.

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question