Satech Jubara
asked on
I want to put down the graph icon working auto for total sales in all months (all period )
Dear ,
I have a sales chart from the beginning of the year until July, I put the label which reflects the value of the sales each month, I want to put down the graph icon working auto for total sales in all months (all period )
for more details see the attached
Thanks
sales-v--2-.png
I have a sales chart from the beginning of the year until July, I put the label which reflects the value of the sales each month, I want to put down the graph icon working auto for total sales in all months (all period )
for more details see the attached
Thanks
sales-v--2-.png
ASKER
I simply want to sum all the Label Points and put the total
Thanks
Thanks
The only way I can think to automatically include a label with the total to date is to create a total column in the data and include it in the graph data range. However this will throw the graph size off as it will auto adjust the axis for the total.
You could maybe divide the total by a factor of 1000 and display it on a second axis to reduce the impact on the size of the graph.
You could maybe divide the total by a factor of 1000 and display it on a second axis to reduce the impact on the size of the graph.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solved..Thank you Henson
Can you upload a sample excel file rather than an image?