Can you do a Ven Diagram in excel?

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

Guest

I have tried to use 2 axis within a pivot report however you are unable to
say use a scatter graph? I have 2 sets of results against row. Some of these
results are positive some negative I need to see all positive in the centre
of the graph. Then moving out to the either end of the graph for negative
results. Hope this makes a little sense.
 
Pivot Charts are rather limited in how you can format them. No XY
charts, for example. But you can make a real chart out of a pivot chart.

Start by selecting a cell that's away from the pivot table, and start
the chart wizard. Choose the type you want in step 1, and in step 2
click on the series tab. One series at a time, press Add, then select
the range with the X values and the range with the Y values. Don't
select one of the pivot buttons, or it will turn into a pivot chart, and
you'll have to start over.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top