View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default Adding Year Field To Dynamic Chart

Nel post
*Acro* ha scritto:

I have created a chart that gets the last twelve months of my data
from a pivot table. These graphs of my data have turned out
beautifully except for the fact that they say what month the data is
but do not clarify what year I am talking about. I wonder if there
is a way to get my graph to not only display the month but also the
year?


I think you can format the labels to display the year. Select the labels,
right click, Format labels, choose the tab Number, Category Custom, type:
mmm yyyy to see labels as Jun 2006 or type mmmm yyyy to see June 2006, and
so on.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy