View original (French)

Round the data in a chart

Solved
vasigui Posted messages 7 Status Member -  
vasigui Posted messages 7 Status Member -
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

4 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    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.
    2
  2. vasigui Posted messages 7 Status Member
     
    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
    0
  3. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    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".
    0
  4. vasigui Posted messages 7 Status Member
     
    Thank you very much for your response.

    That works!!

    See you soon

    Vasigui
    0