Excel Waterfall Charts are easy in Excel for Office 365, but I'll show you a. It makes light work of building what was a laborious chart to create in earlier versions of Excel. For the most part it isn't a problem, but I really dislike the category labels rotated vertically and the only. It's available for PC and Mac.
264How can I make an Excel chart refer to column or row headings?Excel 2013 and Excel 2016Arrange your data so that headings are directly above and to the left of the data to be charted. There should be no blank rows or columns.
Make sure that you select the headings as well as the data before you create your chart.If you have already created your chart:. Click on the chart to select it. Click the Chart Filters button. Click Select Data.
At the bottom right of the dialog. In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK. In the dialog box under Legend Entry Series, select the first series and click Edit. In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, click OK. Repeat for each series of data.
Click OK.Excel 2010Arrange your data so that headings are directly above and to the left of the data to be charted. No blank rows or columns.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |