堆叠条形图自定义格式 [英] stacked bar chart custom format

问题描述

我有一个堆叠条形图excel。这是由正面评论和负面评论组成。我可以从轴的一侧获得负面主题名称，但无法解决如何获得图表右侧的正面。

从示例附加我想要在图的左侧和右侧的轴标题？我已经停留了几天，并已经研究了这个。

<解决方案

您可以做的是：

1. 添加一系列新的数据，


2. 格式化新系列以在辅助轴上绘制


3. 添加辅助 .ms / 1xrnjBgrel =nofollow> http://1drv.ms/1xrnjBg
   
   

   I have a stacked bar chart in excel. This is made up of positive and negative comments. I can get the negative topic names down one side of the axis but can't work out how to get the positive down the right hand side of the chart?

   From the example attached I want the axis titles on both the left and right of the graph? I've been stuck on this for a few days and have researched this.

   Thank you in advance for any help!

   解决方案

   What you can do is:

   1. Add a new series of data plotting a value of 0 for each category, and using your "good" labels for the category axis data.
   2. Format the new series to plot on a secondary axis
   3. Add a secondary vertical axis, and format it to display the categories in reverse order

   Demo file here: http://1drv.ms/1xrnjBg

   这篇关于堆叠条形图自定义格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！