I have a lot of charts to make, I'm using a pivot table to bring up the data
for the different charts. I have a list of months and 2 columns of numbers.
What I'm trying to figure out is if there is a way I can make the chart have
a month be italicized if one of the 2 columns has no data as opposed to just
a zero.

Hi,

If you asking can you format one of the X-axis labels to Italic while
keeping the others normal. Not with the built in axis. First you could
create a dummy x-axis and depending on how you choose to impliment that you
could manually format any label or you could write code to automate the
process.

Check out Jon Pelier's web sit for step by step instructions on creating
dummy axis.

http://peltiertech.com/Excel/Charts/

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Bolgomar" wrote:

I have a lot of charts to make, I'm using a pivot table to bring up the data
for the different charts. I have a list of months and 2 columns of numbers.
What I'm trying to figure out is if there is a way I can make the chart have
a month be italicized if one of the 2 columns has no data as opposed to just
a zero.

Thanks, I actually came up with a better idea, of just adding an astrek to
the months as opposed to italics, easier and works just as well.

"Shane Devenshire" wrote:

Hi,

If you asking can you format one of the X-axis labels to Italic while
keeping the others normal. Not with the built in axis. First you could
create a dummy x-axis and depending on how you choose to impliment that you
could manually format any label or you could write code to automate the
process.

Check out Jon Pelier's web sit for step by step instructions on creating
dummy axis.

http://peltiertech.com/Excel/Charts/

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Bolgomar" wrote:

I have a lot of charts to make, I'm using a pivot table to bring up the data
for the different charts. I have a list of months and 2 columns of numbers.
What I'm trying to figure out is if there is a way I can make the chart have
a month be italicized if one of the 2 columns has no data as opposed to just
a zero.