| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple rows of data on a single axis (charting)
I have several rows of data that are separated by several other rows (that I
don't want to chart). Is there a way to chart several rows of data on one continuous axis? For example (see below) I want to chart Row 1, Row 3 and Row 5 on one axis that would show a trend of 25, 50, 75, 5, 10, 15, 1, 2, 3. I have tried separting the rows with comas, colons, &, "", + and can't get it to work. I don't want to copy and paste the data into a new format b/c that will take too much time. Any suggestions? Column A Column B Column C Row 1 25 50 75 Row 2 10 20 30 Row 3 5 10 15 Row 4 2 4 6 Row 5 1 2 3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
| Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
| Secondary Axis Without Data Points? | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
