Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
scatered charts
How could I use a scatered chart so that it funsction as a linear chart
connectingpoints of the series while it still allowes me to use the numerical scale to change the minimum and maximum values, and ranges, etc. On the same topic, if this is possible how do i also add the possibility to create a secondary y axes while still having the ability to show one y axis with bars and the second with lines. thanks, please reply to |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
scatered charts
In A1 type X, in B1 type y1 and in C1 type y2
In A2:A10 enter the numbers 1,2,3,4.... In B2 enter the formula =2*A2+6 and copy down to B10 (the quickest way is to double click B2's fill handle - the small black square in lower right corner of the active cell) In C2 enter =20*A2+5 and copy down to C10 Select A1:C10; click on the Chart Wizard; select XY type chart and for a subtype use one with lines and markers In chart, double click the line for Y2 and in the Format Data Series dialog, open the Axis tab and click on Secondary Axis. If you want to lean to use Excel may I suggest a book such as Excel for Dummies best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email " wrote in message ... How could I use a scatered chart so that it funsction as a linear chart connectingpoints of the series while it still allowes me to use the numerical scale to change the minimum and maximum values, and ranges, etc. On the same topic, if this is possible how do i also add the possibility to create a secondary y axes while still having the ability to show one y axis with bars and the second with lines. thanks, please reply to |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
How To Change Fonts In Multiple Charts in a Workbook? | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel |