sliding scale chart

M

mon

I would like to make a simple straight line chart with
values y-value*1.15 =x-value.
Probably very simple, but I am having trouble. Thanks Mon
 
B

Bernard Liengme

1) in A1 and B1 enter the letters X and Y
2) in A2:A11 enter 1,2,3,...
3) in B2 enter =A2*1.15
4) copy this down the B column (simplest way is to double click the fill
handle on B2)
5) use mouse to select A1:B11
6) click Chart Wizard in Toolbar, in Step 1 select XY chart
7 ) the rest is optional and you should read a BOOK on how to get charts
looking the way you want them
Season's Greetings
 
T

Tushar Mehta

In addition to Bernard's suggestion, you might want to check the Excel
| Add-Ins | Chart Manager page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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