| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get the axis titles to display properly in ms graph 03? | Charts and Charting in Excel | |||
| Formatting Chart Axis - Bar Graph | Charts and Charting in Excel | |||
| Need 2 rows to display X axis data points for a line graph | Charts and Charting in Excel | |||
| prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
| Exell graph cannot display the Y axis on my 16/10 notebook comput. | Charts and Charting in Excel | |||
Linear Mode
