Graph - Display Y axis data at top of chart(?)
 

Hello. I want to generate a gantt type chart (stacked bar) with months (Jan
- Dec) at the Y axis. I want the values to display at the top of the chart as
opposed to the bottom. Can this be done? I've played around a bit with my
data columns but haven't been able to crack the code. Any help, is as
always, certainly appreciated.

Graph - Display Y axis data at top of chart(?)
 

select the months on the axis and double click
on patterns select "tick mark lables" high

"Suzanne" wrote:

Hello. I want to generate a gantt type chart (stacked bar) with months (Jan
- Dec) at the Y axis. I want the values to display at the top of the chart as
opposed to the bottom. Can this be done? I've played around a bit with my
data columns but haven't been able to crack the code. Any help, is as
always, certainly appreciated.

Graph - Display Y axis data at top of chart(?)
 

BJ thank you, i'll give it a try.

"bj" wrote:

select the months on the axis and double click
on patterns select "tick mark lables" high

"Suzanne" wrote:

Hello. I want to generate a gantt type chart (stacked bar) with months (Jan
- Dec) at the Y axis. I want the values to display at the top of the chart as
opposed to the bottom. Can this be done? I've played around a bit with my
data columns but haven't been able to crack the code. Any help, is as
always, certainly appreciated.

Graph - Display Y axis data at top of chart(?)
 

Like a charm. Thanks!

"bj" wrote:

select the months on the axis and double click
on patterns select "tick mark lables" high

"Suzanne" wrote:

Hello. I want to generate a gantt type chart (stacked bar) with months (Jan
- Dec) at the Y axis. I want the values to display at the top of the chart as
opposed to the bottom. Can this be done? I've played around a bit with my
data columns but haven't been able to crack the code. Any help, is as
always, certainly appreciated.

Graph - Display Y axis data at top of chart(?)
 

The "official" way would be to double click the vertical axis (which
presumably shows the task names), and on the Scale tab, change the setting
for Value (Y) Axis Crosses At and for Categories in Reverse Order.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"bj" wrote in message
...
select the months on the axis and double click
on patterns select "tick mark lables" high

"Suzanne" wrote:

Hello. I want to generate a gantt type chart (stacked bar) with months
(Jan
- Dec) at the Y axis. I want the values to display at the top of the
chart as
opposed to the bottom. Can this be done? I've played around a bit with
my
data columns but haven't been able to crack the code. Any help, is as
always, certainly appreciated.

Graph - Display Y axis data at top of chart(?)
 

Thank you Jon. This is great stuff, i appreciate the assistance.

"Jon Peltier" wrote:

The "official" way would be to double click the vertical axis (which
presumably shows the task names), and on the Scale tab, change the setting
for Value (Y) Axis Crosses At and for Categories in Reverse Order.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"bj" wrote in message
...
select the months on the axis and double click
on patterns select "tick mark lables" high

"Suzanne" wrote:

Hello. I want to generate a gantt type chart (stacked bar) with months
(Jan
- Dec) at the Y axis. I want the values to display at the top of the
chart as
opposed to the bottom. Can this be done? I've played around a bit with
my
data columns but haven't been able to crack the code. Any help, is as
always, certainly appreciated.