ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Switch order of series name and value as displayed in chart (https://www.excelbanter.com/charts-charting-excel/247149-switch-order-series-name-value-displayed-chart.html)

Jazz

Switch order of series name and value as displayed in chart
 
I have a column chart with three separate columns. I want to include the
series name and the value in the chart, however I want to display the series
name after the value. Presently

Column 1 displays - Day(s)9

Column 2 displays - Day(s)5

Column 3 displays - Days(s)15

Can you tell me how I can change the chart so the series name and value will
display themselves like this?

Column 1 displays - 9 Day(s)

Column 2 displays - 5 Day(s)

Column 2 displays - 15 Day(s)



Luke M

Switch order of series name and value as displayed in chart
 
Have the data label only display value. Then, format the label, go to the
number tab, and give it a custom format of:
#" Day(s)"

Not perfect, but it'll get the desired results, and I would presume that
your series name is not going to be cosntantly changing.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jazz" wrote:

I have a column chart with three separate columns. I want to include the
series name and the value in the chart, however I want to display the series
name after the value. Presently

Column 1 displays - Day(s)9

Column 2 displays - Day(s)5

Column 3 displays - Days(s)15

Can you tell me how I can change the chart so the series name and value will
display themselves like this?

Column 1 displays - 9 Day(s)

Column 2 displays - 5 Day(s)

Column 2 displays - 15 Day(s)




All times are GMT +1. The time now is 06:06 AM.

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