Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel chart based on 2 scales
- Thread starter Caro100
- Start date
SkipVought
Programmer
Hi,
Set up your chart INITIALLY with only one series.
COPY the data range for the second
Select the chart - Edit/Paste Special-Values -- this adds the second series.
With the new series selected, Chart/Chart Type and select Line
With the new series selected, Chart/Chart Options-Axis Tab and select the secondary axis
With the new series selected, Chart/Chart Type and select Column
VOLA!
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Set up your chart INITIALLY with only one series.
COPY the data range for the second
Select the chart - Edit/Paste Special-Values -- this adds the second series.
With the new series selected, Chart/Chart Type and select Line
With the new series selected, Chart/Chart Options-Axis Tab and select the secondary axis
With the new series selected, Chart/Chart Type and select Column
VOLA!
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status
Similar threads
