sliding scale chart

  • Thread starter Thread starter mon
  • Start date Start date
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
 
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
 
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
 
Back
Top