![]() Start Microsoft Excel. Click into the first column and type a number to use for plotting on a graph. Press the “Enter” key and type the next number. Continue filling the A column until the numbers for the graph are all entered. Click into column B, cell one. Fill in numbers for the graph. Quick Tip: Excel 2013 offers flexible data labels. You can't create a multi-object selection. You can use shapes to draw attention to labels - Excel calls them callouts. Right-click the. OK, I think I found what you describe. The data source for your chart is a pivot table that has the year as the first level of the hierarchy and the month nested beneath. That does not work for a multi-level category. Select the Pivot Table and on the DESIGN ribbon click 'Report Layout > Show in Tabular Form'. Now the years and the months are in different columns. Your chart does not show anything useful at all, so you now need to edit your chart source and re-do the data and label (category) selection. For the X axis you need to select ='Open SR Pivots'!$A$13:$B$17 Here are a few screenshots.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. Архивы
Март 2019
Категории |