Charting a linear equation

J

Joseph L. Casale

I have a chart in excel 2007, the X series is edited to be:

={0,150000}

The Y series needs to be a formula,

=2X+1000



How can I enter this in so it leverages X in its calculation. I know I can
make cells that do the calcs, but cant this be written up in the series
editor without using extra cells?



Thanks!

jlc
 
D

Del Cotter

How can I enter this in so it leverages X in its calculation. I know I can
make cells that do the calcs, but cant this be written up in the series
editor without using extra cells?

Are they taking the cost of cells out of your wages where you work? :)

Excel is a spreadsheet, cells is what it *does*. It happens to have an
underdeveloped and undersupported little charting facility bundled in
with it, to display the contents of the cells.

However, Stephen Bullen has a novelty spreadsheet called ChtFrmla.zip
that may do what you want, see if it helps. It's on his web page

http://www.oaltd.co.uk/Excel/Default.htm
 
J

Joseph L. Casale

Thats exactly what I need!
Wage remains the same, I just wanted some clean way to dictate how many
points without using many cells and making myself have to paste formula.

Thanks!
jlc
 

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

Top