Insert pie chart in Excel macro function

Question

I'm new to using macros. I've been attempting to use an Excel macro tool to insert a pie chart on the Subject name fields (X, Y, and Z). When the user clicks a macro command button, this graph should be able to be drawn. In essence, it should count, and then produce the chart using the result.

Here is an example of current data:

Channel_Type | Channel_Category | Category | **Subject_Name**
  MICROBLOG          General         A           X
   Forum             General         A           Z
   BLOG              General         A           Y
   FORUM             General         A           X
  MICROBLOG          General         A           Z
   BLOG              General         A           Z

Here is the desired outcome:

X : 2 | Y : 1 | Z : 3

This is what i tried before to plot the graph for the whole sheet but i am unsure of how to just select one column:

Option Explicit

Sub Example()
Dim cht As ChartObjects
For Each cht In Worksheets(1).ChartObjects

Next cht
cht.Chart.ChartType = xlPie


End Sub

Answer 1

Think about arranging your data in a table with a count column at the very end. If you enter =1 here, it will automatically fill in the values for each row (assuming that each row has a unique record). Use the "Subject name" and "count" variables to create a pivot chart (pie chart). If you must use VBA, you can then link the pivottable's refresh to a command button, which will cause the chart to update whenever the button is pressed. Because the data is in an Excel table, it will also add new rows as they are added.