LIne chart problem

F

Frustrated teacher

I'm trying to set up a simple supply and demand chart in Excel 2007. I've
done this many times with past versions but can't get this to work in 2007.
Basically I want the price of the product on the y-axis (can't MS call it
that, please?) then supply to run upward with the number of products on the
x-axis and demand to run downward. I can't get the price on the y-axis no
matter what I try. I've looked everywhere online, but switch row/column and
using a secondary axis don't work. This should be so simple. Argh!
 
F

Frustrated teacher

I figured this out myself, after I looked at Jon Peltier's website. Thanks,
Jon. If you want an intersecting line chart, USE AN XY CHART! I still think
MS could spend some money to make their charting more user friendly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switching X and Y axis 4
How do I create a supply and demand chart? 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Positioning x axis at bottom of chart with negative values 5
Chart - Secondary Y-axis with different values/scale 2
Using the full width of an Excel chart with two Y-axes 2
Supply and Demand Charting 2
Help with Bar-Line Chart..not aligned?? 1

Top