Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I change the order of items in a graph legend?
Hello, I am trying to create charts for different timframes, have listed the
data in similar fashion in two different spread sheets. When I create graphs, the order of legend is not identical in the two graphs. It needs to be consistent. Appreciate any help along these lines. Thanks, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I change the order of items in a graph legend?
Hi,
You can use the series order option in the format dialog to change the order. Double click a series to display the format dialog. Note though that the series need to be of the same chart type and on the same axis in order to manipulate the series order. Cheers Andy NsShak wrote: Hello, I am trying to create charts for different timframes, have listed the data in similar fashion in two different spread sheets. When I create graphs, the order of legend is not identical in the two graphs. It needs to be consistent. Appreciate any help along these lines. Thanks, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change a legend in Pivot Chart Report | Excel Discussion (Misc queries) | |||
overlay average & goal lines to bar graph w/out showing in legend | Charts and Charting in Excel | |||
Can you reformat order of items in Pivot Tables after refresh? | Excel Discussion (Misc queries) | |||
How do I change the order of the legend entries? | Charts and Charting in Excel | |||
graph displayed in ascending order of value? | Charts and Charting in Excel |