ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data series label in Stacked Chart (https://www.excelbanter.com/charts-charting-excel/134604-data-series-label-stacked-chart.html)

connie

Data series label in Stacked Chart
 
Let me explain by an example:

I am making a Stacked Chart for 1st Quarter of Sales from dffierent Staff

Month Staff Sales
Jan A 100
Jan B 200
Feb A 400
Mar C 100
Mar D 600

Staff B has record in Jan only. When I choose to show the data series on the
Stacked Chart, the name of B appear on Feb and Mar also at 0 level. I want
the name of Staff B Data series label only appear in Jan.

How can the chart show the data series label which has data(sales) only?


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com