Hello,

Let's say that I have the following data in excel which I want to graph as a column chart (months on the x-axis, # vipers sold on the y-axis):

month # Vipers sold
Jan 5
Feb 5
Mar 4
Jun 4

Would it be possible to add more data into excel so that the month text of Mar and Jun are red in the chart (I would like the word "mar" and "jun" to be red in the column chart, not the bar of size of 4) while the words Jan and Feb are blue? Right now, all my x-axis titles/names/values are black.

I ask because I need to change the month data within a pivot chart, and I'm hoping that if I at least know how to do this in the above easier example, I can incorporate what I learn into my pivot table.

thank you so much,
michael