Re: Figures in data box and percentages in graph

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I had a look at the site, and did a few other searches, and I think the only
way you can do this, as you say is fake it!

Had hoped there was some setting or trick I had missed.

Andrew

"Jon Peltier" <jonREMOVExlmvp@xxxxxxxxxxxxxxxxxxx> wrote in message
news:%23i64pcTpFHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
> You need to fake the data table. Tushar Mehta has a discussion of data
> tables and alternatives on his web site, http://tushar-mehta.com.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> andreww wrote:
>
>> Hi - I have a client for whom we have developed a report system. They now
>> want an ammendment to some of the graphs which means that they want to be
>> able to see the actual figures in the data box under the graph and the
>> bars/lines in the body of the graph to be based on percentages.
>>
>> Does anyone have any ideas on this?
>>
>> Regards
>>
>> Andrew


.



Relevant Pages

  • Re: Y axis, need varying units
    ... You just have to figure out how to tell Excel what to graph. ... >>Jon Peltier, Microsoft Excel MVP ... >>Peltier Technical Services ...
    (microsoft.public.excel.charting)
  • Re: Activechart.SetSourceMethod problem
    ... Jon Peltier, Microsoft Excel MVP ... Peltier Technical Services ... > range for which the graph should plot. ... > there are a variable number of column sets which contain similar data ...
    (microsoft.public.excel.programming)
  • Re: Excels XY Plotting Question?
    ... Jon Peltier, Microsoft Excel MVP ... Peltier Technical Services, Inc. - http://PeltierTech.com ... and make a change to the cell number so the graph is right! ... so, the graph would be WRONG since it was designed for 5 points, now ...
    (microsoft.public.excel.programming)
  • Re: How to ignore zero values when plotting a graph
    ... Debra Dalgleish shows how to hide the ugliness with ... Jon Peltier, Microsoft Excel MVP ... Peltier Technical Services ... the graph line (a simple ...
    (microsoft.public.excel.charting)
  • Re: X axis lables on a + and - scale?!?
    ... Double click on the axis, and on the Patterns tab, select the Low option for Tick ... Jon Peltier, Microsoft Excel MVP ... Peltier Technical Services ... > The problem is that I want to show the X axis labels on the graph but ...
    (microsoft.public.excel.charting)