Home |
Search |
Today's Posts |
#1
|
|||
|
|||
edit x-values in XY Scatter?
If I want to change x-values in a multi-series X-Y scatter
I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7 x-values (even though the new x-values are the same for all series) i must've missed something - isn't there a way to set the same x-values for all series at once no-coding solutions - thanx |
#2
|
|||
|
|||
Hi,
Sounds like you need to edit the x values data ranges for your series so they all use the same set of x values. Use the source data dialog to update your data references. Or is the chart is on a worksheet select the data series and then drag the coloured highlighting box over to the shared x-values range. Cheers Andy JethroUK© wrote: If I want to change x-values in a multi-series X-Y scatter I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7 x-values (even though the new x-values are the same for all series) i must've missed something - isn't there a way to set the same x-values for all series at once no-coding solutions - thanx -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Hi
I'm using the 'source data' dialogue - but there doesn't seem to anyway to edit the x values for all series at one time - each series seems to have it's own x-values (although i want the same x-value for all series) - i have to select each series in turn and do it series-by-series (7 series - 7 edits of the same x-values) i've tried dragging new x values onto the x-axis of the chart - but it just adds it as yet another series in the chart (not on the x-axis) "Andy Pope" wrote in message ... Hi, Sounds like you need to edit the x values data ranges for your series so they all use the same set of x values. Use the source data dialog to update your data references. Or is the chart is on a worksheet select the data series and then drag the coloured highlighting box over to the shared x-values range. Cheers Andy JethroUK© wrote: If I want to change x-values in a multi-series X-Y scatter I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7 x-values (even though the new x-values are the same for all series) i must've missed something - isn't there a way to set the same x-values for all series at once no-coding solutions - thanx -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
You will have to change each series individually.
Cheers Andy JethroUK© wrote: Hi I'm using the 'source data' dialogue - but there doesn't seem to anyway to edit the x values for all series at one time - each series seems to have it's own x-values (although i want the same x-value for all series) - i have to select each series in turn and do it series-by-series (7 series - 7 edits of the same x-values) i've tried dragging new x values onto the x-axis of the chart - but it just adds it as yet another series in the chart (not on the x-axis) "Andy Pope" wrote in message ... Hi, Sounds like you need to edit the x values data ranges for your series so they all use the same set of x values. Use the source data dialog to update your data references. Or is the chart is on a worksheet select the data series and then drag the coloured highlighting box over to the shared x-values range. Cheers Andy JethroUK© wrote: If I want to change x-values in a multi-series X-Y scatter I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7 x-values (even though the new x-values are the same for all series) i must've missed something - isn't there a way to set the same x-values for all series at once no-coding solutions - thanx -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
cracked it - if anyone else needs this work around
change chart type to std 'column chart' edit as "x-labels" change chart type back to 'X-Y scatter' presto :o) i cant beleive it worked (used x-labels as x-values) but it did - because a column chart can only have one range x labels i could edit it one shot - changing the bar back to X-Y chart, it used the x-label as x-values for all the series "Andy Pope" wrote in message ... You will have to change each series individually. Cheers Andy JethroUK© wrote: Hi I'm using the 'source data' dialogue - but there doesn't seem to anyway to edit the x values for all series at one time - each series seems to have it's own x-values (although i want the same x-value for all series) - i have to select each series in turn and do it series-by-series (7 series - 7 edits of the same x-values) i've tried dragging new x values onto the x-axis of the chart - but it just adds it as yet another series in the chart (not on the x-axis) "Andy Pope" wrote in message ... Hi, Sounds like you need to edit the x values data ranges for your series so they all use the same set of x values. Use the source data dialog to update your data references. Or is the chart is on a worksheet select the data series and then drag the coloured highlighting box over to the shared x-values range. Cheers Andy JethroUK© wrote: If I want to change x-values in a multi-series X-Y scatter I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7 x-values (even though the new x-values are the same for all series) i must've missed something - isn't there a way to set the same x-values for all series at once no-coding solutions - thanx -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
Nice work around! and thanks for sharing it.
Cheers Andy JethroUK© wrote: cracked it - if anyone else needs this work around change chart type to std 'column chart' edit as "x-labels" change chart type back to 'X-Y scatter' presto :o) i cant beleive it worked (used x-labels as x-values) but it did - because a column chart can only have one range x labels i could edit it one shot - changing the bar back to X-Y chart, it used the x-label as x-values for all the series "Andy Pope" wrote in message ... You will have to change each series individually. Cheers Andy JethroUK© wrote: Hi I'm using the 'source data' dialogue - but there doesn't seem to anyway to edit the x values for all series at one time - each series seems to have it's own x-values (although i want the same x-value for all series) - i have to select each series in turn and do it series-by-series (7 series - 7 edits of the same x-values) i've tried dragging new x values onto the x-axis of the chart - but it just adds it as yet another series in the chart (not on the x-axis) "Andy Pope" wrote in message ... Hi, Sounds like you need to edit the x values data ranges for your series so they all use the same set of x values. Use the source data dialog to update your data references. Or is the chart is on a worksheet select the data series and then drag the coloured highlighting box over to the shared x-values range. Cheers Andy JethroUK© wrote: If I want to change x-values in a multi-series X-Y scatter I have to edit x-values seperately for each series e.g i have 7 series - i have to edit all 7 x-values (even though the new x-values are the same for all series) i must've missed something - isn't there a way to set the same x-values for all series at once no-coding solutions - thanx -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
How to switch to edit the cell | Excel Discussion (Misc queries) | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions |