H
hughess7
Hi all
Hopefully a few easy questions... I have created a bar chart and I have two
sets of data - one for the totals per area for each dealer and the 2nd is
always set to 100 which is the national average. What I would like is the
legend to display Dealers and National. Currently it displays the value in
the first column which is 141.07 and 100. How do I change this please?
Also, when I view the chart if I turn on the values it displays more than
the 2 decimal places that I have the query column formatted as - how do I set
the decimal places for the chart values?
and lastly if I turn on the values per bar column as above - it changes the
legend to the name of each area (x axis data) even though I didn't tick the
legend box? Is it possible to have the data values displayed on each bar and
the legend just showing the two headings.
Kind Regards
Sue
Hopefully a few easy questions... I have created a bar chart and I have two
sets of data - one for the totals per area for each dealer and the 2nd is
always set to 100 which is the national average. What I would like is the
legend to display Dealers and National. Currently it displays the value in
the first column which is 141.07 and 100. How do I change this please?
Also, when I view the chart if I turn on the values it displays more than
the 2 decimal places that I have the query column formatted as - how do I set
the decimal places for the chart values?
and lastly if I turn on the values per bar column as above - it changes the
legend to the name of each area (x axis data) even though I didn't tick the
legend box? Is it possible to have the data values displayed on each bar and
the legend just showing the two headings.
Kind Regards
Sue