Prev: Adding data labels to bubble charts
Next: can i edit only a selected range of data in an excel chart?
From: Jared on 2 Dec 2009 13:24 I need help trying to get the check box for Multi-level category labels in an excel chart. I have it on one chart, saved it as a template, and then inserted the template into the same spreadsheet. Reslected the new data but it will not give me back the check box option for Multi-Level Category Labels for the new line chart with a data table. I have one month's data and chart above the other. However the new chart horizontal axis label is not the same and I've tried everything. -- Jared
From: Jon Peltier on 3 Dec 2009 19:22
I'm not familiar with such a check box. You get the multitiered labels through designation of a two row or column range for category labels. The template will not know anything about this. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Jared wrote: > I need help trying to get the check box for Multi-level category labels in an > excel chart. I have it on one chart, saved it as a template, and then > inserted the template into the same spreadsheet. Reslected the new data but > it will not give me back the check box option for Multi-Level Category Labels > for the new line chart with a data table. I have one month's data and chart > above the other. However the new chart horizontal axis label is not the same > and I've tried everything. |