Tag Info

Hot answers tagged

2

Create a chart based on a pivot table. In the pivot table, you can add calculated fields, such as / or show an item as a percentage of a row or column.


1

It turns out you can do what you want with the built-in formatting options. Just plot the duration times as they are stored (time values). Right-click on the Y axis and select Format Axis | Number. Among the time formats is a standard format mm:ss.0;@. Select that and it will appear in a customization box. Edit it to read: mm"m"ss"s" and click the Add ...


1

One approach is to use data labels: Single left-click the data series of interest. Single left-click the data point of interest. Right-click; select 'Add Data Label' Single left-click the new data label three times until a cursor appears. You can now enter text into the data label and it should remain attached to the chart data point.


1

To close the loop on this question, I'll move a comment to an answer. The problem appeared to describe selecting a chart style with no markers. The solution to that is using the "Select Chart Type" button to pick a sub-style that shows markers on the icon. Chart types can be changed after the chart is created. The comments indicate that this was the ...


1

Did you try un-selecting the column value of the row and checked your results. Hopefully, there will be a column for every row value. By un-selecting respective column would help you to achieve this. Try the below steps: Right click on the Chart > Select Data > on the "Select Data Source", you have option to edit the value by "Row/Column" > now, un-select ...



Only top voted, non community-wiki answers of a minimum length are eligible