Round the data in a chart
Solved
vasigui
Posted messages
7
Status
Membre
-
vasigui Posted messages 7 Status Membre -
vasigui Posted messages 7 Status Membre -
Hello,
I'm working on Excel 2010 and I have an issue with charts. I would like to round the values of the series that appear in the bars of the chart; they are displayed with two decimal places and I want to round them up. I've gone to the number settings and I can remove the number of decimal places, but it doesn't round up. Thank you for your help.
Vasigui
Configuration: Windows Vista / Internet Explorer 8.0
I'm working on Excel 2010 and I have an issue with charts. I would like to round the values of the series that appear in the bars of the chart; they are displayed with two decimal places and I want to round them up. I've gone to the number settings and I can remove the number of decimal places, but it doesn't round up. Thank you for your help.
Vasigui
Configuration: Windows Vista / Internet Explorer 8.0
4 réponses
Hello,
Indeed, ArrondiSup is a function but not a format option.
A simple solution is to create a column X = ArrondiSup(value field) and plot the graph with this column X.
Plotting the actual values and only rounding the label values would be more complicated and hence unnecessary.
Indeed, ArrondiSup is a function but not a format option.
A simple solution is to create a column X = ArrondiSup(value field) and plot the graph with this column X.
Plotting the actual values and only rounding the label values would be more complicated and hence unnecessary.
Thank you Tontong
for this prompt response, it's true I could do as you say and it's a big step forward,
what troubles me is that I have examples of graphs made in version 2003 where it was possible but I don't know how.
In any case, I find that creating graphs was easier before,
2010 undoubtedly brought improvements in format but it's less pleasant for the rest.
The discussion remains open.
vasigui
for this prompt response, it's true I could do as you say and it's a big step forward,
what troubles me is that I have examples of graphs made in version 2003 where it was possible but I don't know how.
In any case, I find that creating graphs was easier before,
2010 undoubtedly brought improvements in format but it's less pleasant for the rest.
The discussion remains open.
vasigui
The 2003 solution applied may be as follows:
The "real" series is plotted without labels.
A series is added plotted with the rounded values (X column) and with the rounded values as labels.
This series is made invisible (no line, no marker).
You can also add labels with a macro or an add-in like XY ChartLabeler.
Most of the "2003" solutions are also applicable with "2010".
The "real" series is plotted without labels.
A series is added plotted with the rounded values (X column) and with the rounded values as labels.
This series is made invisible (no line, no marker).
You can also add labels with a macro or an add-in like XY ChartLabeler.
Most of the "2003" solutions are also applicable with "2010".