Overlaid Charts

  • Thread starter Thread starter Reney Langlois
  • Start date Start date
R

Reney Langlois

Hi, you'll like this one. I've overlaid an X-Y scatter
chart with another that contains different source data. I
formatted the background of the "top" chart so that when I
click back onto the spreadsheet, I can see both plots. The
reason I did this is that my second source of data (top
chart) is not of the same type as the first source and I
didn't know how to create two separate "Y"'s for an X-Y
scatter plot. My question is, moving forward in this
mode, is there a way to select and format the "bottom"
chart other than moving the top one slightly out of the
way to allow me to select it? Alternately, is there a way
to do an X-Y scatter plot with two Y axes? I'm trying to
maintain scaleabilty in time on my X axis which is why I'm
not using a "line" type plot.
 
There's a useful, but well hidden, tool that you can use to select objects:

1. Choose Tools>Customize
2. Select the Commands tab
3. Select the Drawing Category
4. Drag the 'Select Multiple Objects' tool onto one of your toolbars
5. Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.

Or, to create a secondary Y axis, select one of the series in the chart
Choose Format>Selected Data Series
 
that is an useful tool. But what are the various circumstance one can use
this tool
Besides only embedded charts are shown as object in thae <selected multiple
objects>window.
 
It's a good way to see a summary of all the objects on a sheet,
including those that have been hidden under other objects, or reduced in
size.
To see a list of objects from the control toolbox, enter Design mode.
 
Back
Top