Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Year Field To Dynamic Chart
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? -- Acro ------------------------------------------------------------------------ Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456 View this thread: http://www.excelforum.com/showthread...hreadid=556663 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding lines of data to an area chart | Excel Discussion (Misc queries) | |||
Dynamic Step Chart using range names | Charts and Charting in Excel | |||
Automation of Dynamic Chart Title and legend changes | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) |