Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Display Order in Charts
I have an X-Y chart with a cloud of points and a line. When the chart plots,
the line is always hidden behind the cloud of points. Can I bring the line to the top so it becomes visible? I tried making the line first and last, but it always ends up behind the cloud. Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Display Order in Charts
Lines for a given chart group (group of data series) are plotted behind
points of that same chart group in an XY chart. However, you can change the chart group by changing the axis on which the chart group is plotted. Make the plot with one series formatted as markers only and another as lines only, double click the line-formatted series, and on the Axis tab, choose secondary. The line is now drawn in front of the markers. To make sure the series use the same axis scales, delete the visible secondary axes. The secondary series will still be considered as part of the secondary chart group, but lacking secondary axes, it will use the primary axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "lesy99" wrote in message ... I have an X-Y chart with a cloud of points and a line. When the chart plots, the line is always hidden behind the cloud of points. Can I bring the line to the top so it becomes visible? I tried making the line first and last, but it always ends up behind the cloud. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a Chart's axis scale from visual basic? | Charts and Charting in Excel | |||
Change standard layout of excel charts | Charts and Charting in Excel | |||
Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
How to change the tab order for a protected worksheet | Excel Worksheet Functions | |||
How do I change the default settings in charts? | Charts and Charting in Excel |