Hi all,
In the attached a sample file i have to make a bar chart and to add the name of the series below each bar.
but when i mark the x-labels i only get the first value name "a".
but i need to show all the names (a-f).
How can i do this ?
Thanks in advance.
Because the workbook is right to left I think you need to alter the layout of your data so the labels appear in the first column with values in the second.
Currently your chart is plotting multiple series with 1 category. This means the names are in the legend. You could use the Set Source Data dialog to redefine range used.
First remove all but 1 series. The set the range references to
Values: =גיליון1!$D$4:$D$9
Category Labels: =גיליון1!$E$4:$E$9
Series formula will then look like this,
=SERIES(גיליון1!$D$3,גיליון1!$E$4:$E$9,גיליון1!$D$4:$D$9,1)
Thanks for the quick reply.
I do not exactly understand what you meant, I appreciate if you could please attach an example file.
Example attached, which includes screen shot of Set Source dialog
thank's
It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks