HOW TO INCREASE $ INCREMENTS IN A GRAPH

  • Thread starter Thread starter KEVIN_DC
  • Start date Start date
K

KEVIN_DC

I found it incredibly difficult to try and articulate this question.... I
have a graph. Across the bottom I have the months of the year. Running
vertically on the left I have $ increments in the 10's of thousands. I'm
making a graph to represent fuel sales. I need the $ increments to be smaller
so that the viewer of the graph can get a better idea of the nuances, the
subtle waxing and wanning of fuel sales month by month. Does this make sense?
Any help would be greatly appreciated!
 
Okay, so I simply adjust the scale of the value axis to the increment I like?
If I want the $ to be displayed in thousand dollar increments, then I would
adjust the minor and major values to reflect a lower value, like 1,000 and
2,000 respectivley?

Thanks



Echo S said:
Double-click that axis and then go to the Scale tab....

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


KEVIN_DC said:
I found it incredibly difficult to try and articulate this question.... I
have a graph. Across the bottom I have the months of the year. Running
vertically on the left I have $ increments in the 10's of thousands. I'm
making a graph to represent fuel sales. I need the $ increments to be
smaller
so that the viewer of the graph can get a better idea of the nuances, the
subtle waxing and wanning of fuel sales month by month. Does this make
sense?
Any help would be greatly appreciated!
Click to expand...
Click to expand...
 
Yes. Adjust the major and minor values to be the increments you want. If
necessary, adjust the minimum and maximum values to reflect the top and
bottom values on the axis.

There's also a "display units" dropdown on that Scale tab where you can opt
to display the units in hundreds or thousands or millions or whatever. I
find this especially useful when I'm working with charts where there are
lots and lots of zeros. Using the "display units" option eliminates those.

If you need dollar symbols or additional decimal places or whatever format,
choose the Number tab and select your number format there.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


KEVIN_DC said:
Okay, so I simply adjust the scale of the value axis to the increment I
like?
If I want the $ to be displayed in thousand dollar increments, then I
would
adjust the minor and major values to reflect a lower value, like 1,000 and
2,000 respectivley?

Thanks



Echo S said:
Double-click that axis and then go to the Scale tab....

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


KEVIN_DC said:
I found it incredibly difficult to try and articulate this question....
I
have a graph. Across the bottom I have the months of the year. Running
vertically on the left I have $ increments in the 10's of thousands.
I'm
making a graph to represent fuel sales. I need the $ increments to be
smaller
so that the viewer of the graph can get a better idea of the nuances,
the
subtle waxing and wanning of fuel sales month by month. Does this make
sense?
Any help would be greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top