Charting a linear equation

[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

 

[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

 

[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