Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Try It Transcript Change Chart Type Of. In the Labels group click a layout option for the chart label that you want to change. This transcript shows basic data including marital status type of return filed adjusted gross income and taxable income.
This transcript shows basic data including marital status type of return filed adjusted gross income and taxable income. In the Change Chart Type dialog select one line chart type as you need see screenshot. Select the chart.
On the All Charts tab choose Combo and then pick the Clustered Column - Line on Secondary Axis chart.
Wage and Income Transcriptsshow data from information returns such as W-2s 1099s and 1098s reported to the IRS. As seen in the image below you can change the second series type to any other type listed in the drop down. Under Choose the chart type and axis for your data series check the Secondary Axis box for each data series you want to plot on the secondary axis and then change their chart type to Line. If you Hover over the image with your mouse youll see a larger preview.