Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I add series lines to a an excel stacked chart
Hi,
I accessed the Help Menu for this Q. and it says that I have to go to -Format-Select Chart Area-Options Tab. Here, I'd have to select the type of lines I want to use to link a data point on a stacked bar with other data points of the same type on all other stacked bars I have on my chart. I want to use series lines as compared to drop lines or high-low lines...However, there are no line options in the Options Tab. The only options I have a Gap Depth, Gap Width, and Chart Depth. Seems like an error on the Help Menu? Can anyone tell me how can I use series lines. Thanx. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I add series lines to a an excel stacked chart
You should really avoid using chart types with fake 3D styling. In addition
to being unable to use many features of 2D charts, 3d charts are notorious for distorting their data and for being difficult to interpret. Some people think they "look nice", but it's not worth losing information and clarity to make some marketing types or managers think the chart "looks nice". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "kalan" wrote in message ... Hi, I accessed the Help Menu for this Q. and it says that I have to go to -Format-Select Chart Area-Options Tab. Here, I'd have to select the type of lines I want to use to link a data point on a stacked bar with other data points of the same type on all other stacked bars I have on my chart. I want to use series lines as compared to drop lines or high-low lines...However, there are no line options in the Options Tab. The only options I have a Gap Depth, Gap Width, and Chart Depth. Seems like an error on the Help Menu? Can anyone tell me how can I use series lines. Thanx. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I add series lines to a an excel stacked chart
Thanks. I didn't know series lines couldn't be used in 3-D charts.
Kalan. "Jon Peltier" wrote: You should really avoid using chart types with fake 3D styling. In addition to being unable to use many features of 2D charts, 3d charts are notorious for distorting their data and for being difficult to interpret. Some people think they "look nice", but it's not worth losing information and clarity to make some marketing types or managers think the chart "looks nice". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "kalan" wrote in message ... Hi, I accessed the Help Menu for this Q. and it says that I have to go to -Format-Select Chart Area-Options Tab. Here, I'd have to select the type of lines I want to use to link a data point on a stacked bar with other data points of the same type on all other stacked bars I have on my chart. I want to use series lines as compared to drop lines or high-low lines...However, there are no line options in the Options Tab. The only options I have a Gap Depth, Gap Width, and Chart Depth. Seems like an error on the Help Menu? Can anyone tell me how can I use series lines. Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Chart series | Charts and Charting in Excel | |||
Can I split data series in an excel chart? | Charts and Charting in Excel | |||
How can I chart a multi-year time series in Excel? | Charts and Charting in Excel | |||
how do I create a stacked bar chart in excel | Charts and Charting in Excel |