If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. http://www.microsoft.com/office/comm...excel.charting |
#2
|
|||
|
|||
Excel x,y chart type x range must be re-entered each series
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 http://PeltierTech.com/ _______ "Thomas R. Glass" Thomas R. wrote in message news 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting Excel chart series from vb6 | Jim | Charts and Charting | 7 | January 27th, 2006 09:41 AM |
ExceL Options: Add a chart for Box-plot type and Range function | sebafishman | General Discussion | 1 | December 21st, 2005 08:37 PM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |
chartgroups,chartobjects etc-confusion to me | R.VENKATARAMAN | Charts and Charting | 1 | April 10th, 2004 04:09 PM |