Overlay charts in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've figured out how to overlay charts, but can't figure out how to make my
colored charts transparent so that the data from both charts can be read
(like when using an overhead projector and transparencies). I also download
some macro from another question posted on here, thinking it would help, but
it didn't.
 
Hi,

Try setting the chart and plot areas to having no fill. This can be
found on the patterns tab of the format dialog.

Cheers
Andy
 
Overlaying charts is problematic, with Excel autonomously adjusting font
sizes and margins. Could you make a combination chart that displays all
the data in a single chart? What are the chart types?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
My chart types are columns, 2 axes' and target as a line. I have 3 vendors,
multiple parts and quarters I'm presenting on. In my last presentation there
was a recommendation to overlay all 3 vendors data (since they are the same)
to have an easy comparison of who's performing better ... not an easy task.

It's either break it down by part, quarter, or vendor.
 
I've tried that, it's still a white background and the data in the back can't
show through ...
 
Just to be sure, after making the changes the chart will not become
transparent until you deselect it, that is select something other than
the chart.
 
Back
Top