Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two ranges in one series
i want the range for one of my series to be $C$367:$BV367 and $CI$367:$DR$367
but i cant figure out how to write it correctly as it comes up w an error thanks anyone |
#2
|
|||
|
|||
Do these represent X and Y values, or two sets of Y values?
The easiest way is probably to go to Source Data on the Chart menu, select the series if it exists (or click Add if it doesn't), and use the X Values and Y Values boxes to enter the data. The easiest way to use these boxes is to clear what's in one, and select the appropriate range with the mouse. To select a multiple part range, select the first part, then hold CTRL while selecting additional parts. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Micayla Bergen wrote: i want the range for one of my series to be $C$367:$BV367 and $CI$367:$DR$367 but i cant figure out how to write it correctly as it comes up w an error thanks anyone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a dummy series in a chart legend? | New Users to Excel | |||
Quasi Transpose / Stacking Columns | Excel Worksheet Functions | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel |