create pie chart in excel on mac with one column

Extend the capabilities in Origin by installing free Apps available from our website. Origin graphs and analysis results can automatically update on data or parameter change, allowing you to create templates for repetitive tasks or to perform batch operations from the user interface, without the need for programming.

Origin offers an easy-to-use interface for beginners, combined with the ability to perform advanced customization as you become more familiar with the application. Origin is the data analysis and graphing software of choice for over half a million scientists and engineers in commercial industries, academia, and government laboratories worldwide. RS and GIS Data: NetCDF and GeoTIFF Handling and Graphing.Browser Graph for Multichannel Data Exploration.Extended Templates from OriginLab Website.With the formula version the numbers update automatically if you've used a dynamic data range ( = select a single cell from your data and press Ctrl + T to turn it into a table ). The pivot table solution is super easy but if the values change you're going to have to refresh the pivot table to get the new values. The COUNTIF formula gives you the numeric values. In Excel 365 there's the UNIQUE function as well but with older versions you're going to have to enter the unique values manually. The pivot table is by far the easiest way to get all the unique values. The same thing can be done without pivot tables as well but you're going to have to create the two columns yourself. You'll end up with two columns which you can visualize in a chart. Pivot table puts the text values to the row labels but when you drag the same column to the values field as well the pivot table counts the number of values. That being said you can however create a pivot table from your text column. I don't think you can create a chart using text values alone.

Create pie chart in excel on mac with one column