4 field in legend of line chart

  • Thread starter Thread starter afshin
  • Start date Start date
A

afshin

I have a Line chart in Access.i want to have 4 field in legend of chart.but
access don't let to me to do it.
 
While in design view of the chart, you can adjust the size of the legend. If
this doesn't help, you need to provide more significant information about
your chart, what you tried, and your results.
 
I Have a 4 field(value) and 4 fieldes that assign to these fieldes similar:
p1 p2 p3 p4 mapcode1 mapcode2 mapcode3 map code4
10 10 20 30 epf1 epf2 epf3 epf4
12 30 22 50 epf1 epf2 epf3 epf4
25 35 42 65 epf1 epf2 epf3 epf4
that p1 is value of mapcode1, p2 is value of mapcode2 and similar to
p3 and p4.i want to have a linechart with the y-axis for p1,p2,p3 and p4 but
with legend mapcode1,mapcode2,mapcode3 and mapcode4.
but access don't let to me to have a more than one field in legend.
 
I think you only get one legend value per data series or pie slice. What are
you expecting.
I can't see ho p1 is value of mapcode1 since p1 looks like it has values of
10, 12, and 25.
 
when i creat line chart from wizard,access don't let to me to add more than
one field in every legend.
p1 field is the pressure value for mapcode1 field(instrument name),my
intention only is that DATA TYPE of p1 field is number and for mapcode1 is
text.
 
afshin said:
I Have a 4 field(value) and 4 fieldes that assign to these fieldes similar:
p1 p2 p3 p4 mapcode1 mapcode2 mapcode3 map code4
10 10 20 30 epf1 epf2 epf3
epf4
12 30 22 50 epf1 epf2 epf3
epf4
25 35 42 65 epf1 epf2 epf3
epf4
that p1 is value of mapcode1, p2 is value of mapcode2 and similar
to
p3 and p4.i want to have a linechart with the y-axis for p1,p2,p3 and p4
but
with legend mapcode1,mapcode2,mapcode3 and mapcode4.
but access don't let to me to have a more than one field in legend.
Click to expand...
 
I don't understand at all. What is the Row Source of your Chart?
Typically you can display a value in the legend for every data series that
gets plotted. Can you get this to work?
 
I Mistake say that x-axis is date,y-axis is p1,p2,p3&p4(pressure value) and
legend that i want to place there is mapcode1....mapcode4.
i should say that my chart disply legend(with names p1,p2,p3 and p4) but i
want to disply the instrument name of every pressure(epf1 ,epf2, epf3 and
epf4) in legend.
 
I forgot to say that x-axis is date,y-axis is p1,p2,p3&p4(pressure value) and
legend that i want to place there is mapcode1....mapcode4.
i should say that my chart disply legend(with names p1,p2,p3 and p4) but i
want to disply the instrument name of every pressure(epf1 ,epf2, epf3 and
epf4 ) in legend.
 
Your query results need to display the values or fields in order to get them
into the data or the legend. You have completely confused me.

I think you need to provide the significant tables and fields,
relationships, data types, sample data, and how you want these displayed in
your chart.
 
afshin said:
I Have a 4 field(value) and 4 fieldes that assign to these fieldes similar:
p1 p2 p3 p4 mapcode1 mapcode2 mapcode3 map code4
10 10 20 30 epf1 epf2 epf3
epf4
12 30 22 50 epf1 epf2 epf3
epf4
25 35 42 65 epf1 epf2 epf3
epf4
that p1 is value of mapcode1, p2 is value of mapcode2 and similar
to
p3 and p4.i want to have a linechart with the y-axis for p1,p2,p3 and p4
but
with legend mapcode1,mapcode2,mapcode3 and mapcode4.
but access don't let to me to have a more than one field in legend.
Click to expand...
 
Back
Top