Skip navigation

cell formatting: Gb and Mb

423 Views 8 Replies Latest reply: Apr 17, 2013 6:41 PM by PeterBreis0807 RSS
Ajmaq Calculating status...
Currently Being Moderated
Apr 16, 2013 12:05 PM

Hi, I'm using Pages to create a document , i start with a chart and i need to edit the values of it.

I need to place the values in Gigabytes and Megabytes in the same chart, i used the chart data editor but i don't know how to use it or edited

 

please help

Imac, Mac OS X (10.6.5)
  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Apr 16, 2013 1:54 PM (in response to Ajmaq)

    AJ,

     

    If possible, you should acquire Numbers and do your chart there, where you have more options and tools.

     

    You can copy parts of your Numbers document and Paste into Pages for the report.

     

    I'm guessing at what your problem is. Do you want to know how to scale your data so that it will all plot nicely on the same axis, or are you looking for a dual-value axis chart?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Apr 16, 2013 2:25 PM (in response to Ajmaq)

    AJ,

     

    The reason that I suggested that you use Numbers to make your charts is that you could have an auxiliary column that automatically scales your input to a nice range for charting.

     

    Post a screen shot of your data and how you would like to display it and maybe we can come up with a good solution for you. Do you have Numbers.app?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Apr 16, 2013 2:42 PM (in response to Ajmaq)

    AJ,

     

    What you are doing there with Custom Format doesn't change the value of the numeric entry, it just decorates it. Be careful that you don't end up misrepresenting the values.

     

    To mave your work to Pages, Copy the Chart you have made in Numbers and Paste it into Pages.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Apr 17, 2013 12:10 PM (in response to Ajmaq)

    You can scale the data in this way:

     

    Screen Shot 2013-04-17 at 3.10.01 pm.png

    The formula in Column B is:

     

    =A/1000000

     

    Jerry

  • PeterBreis0807 Level 7 Level 7 (27,325 points)
    Currently Being Moderated
    Apr 17, 2013 6:41 PM (in response to Ajmaq)

    A scale is a scale, you can't change horses mid stream.

     

    Referring to comparable measures with different names (measures) is confusing in itself.

     

    I know this from huge errors that have crossed my desk from consultants who should know better. One miscalculated network transfer times by a factor of 8 due to switching back and forth between bits and bytes of data.

     

    Peter

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.