View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
djewkes djewkes is offline
external usenet poster
 
Posts: 5
Default Help desperately needed with excel charts

Hi Fred,
How do I create cells? like i say very much a novice,
best wishes
diane

"Fred Smith" wrote:

The good news is that it's definitely possible.

The first step is to create the cells which display the labels the way you
want. Create a range of cells with the formula I gave you:
=text(a1,"0%")&" [n="&text(a2,"0"),&"]"

Change the cell addresses to suit your situation. When you've got the cells
looking the way you want them on the chart, post back.

Regards,
Fred.

"djewkes" wrote in message
...
Hi Fred,
Have simple excel charts, and have top line of "disagree", "agree",
"neither" etc, and have data in percentages i.e. 30% in each box, have
then
inserted charts of this data which look very pretty, and have numerical
data
in a table, thing is i would really like to combine the two with a
percentage
chart and the data underneath with say 30%[n=9], 60%[n=18], to be honest i
don't think its possible, but any help is very gratefully received,
thankyou
diane

"Fred Smith" wrote:

Let me know what your data looks like.

Regards,
Fred.

"djewkes" wrote in message
...
Hi Fred, thanks but i'm a novice i don't know where to start, could you
give
me a step by step thing please

"djewkes" wrote:

Hi, I really, really need help with excel, I am writing up my
dissertation
and have the results in numbers as well as percentages...i have done
tables
of numbers and charts of percentages, trouble is i want to amalgamate
the
two, ie a percentage chart and underneath...33% [n=9], 66% [n=18], and
i
can't find how to do it, or indeed if its possible, or if its possible
to
add
the numerical data after? thanks in anticipation.