ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   please help me improve the readability of my graph (https://www.excelbanter.com/charts-charting-excel/181033-please-help-me-improve-readability-my-graph.html)

Oresto

please help me improve the readability of my graph
 

Hi, I have 2 excel charts right on the front page of my site.
The issue is that I added the Data Labels to show the daily account
balance, but with more and more days, the numbers get mixed with each
other.

On the scale there was an option to increase the interval to 2, so not
ever day is shown.

Can I do that somehow with Data Labels or is there anything else you
can suggest to me to improve the visibility and readability of this
graph taking into account that it is going to continue for many days.

Many thanks.
the URL is: http://buxto-xorovatz.blogspot.com/




--
Oresto

Jon Peltier

please help me improve the readability of my graph
 
In the top chart, I would switch to data labels without the colored boxes
and shadows. I would also question whether the data labels actually add
anything to the chart. If you need to see the exact numbers, use a table
instead. Or label only the last point, and maybe selected other points, like
the points before and after a transition.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Oresto" wrote in message
...

Hi, I have 2 excel charts right on the front page of my site.
The issue is that I added the Data Labels to show the daily account
balance, but with more and more days, the numbers get mixed with each
other.

On the scale there was an option to increase the interval to 2, so not
ever day is shown.

Can I do that somehow with Data Labels or is there anything else you
can suggest to me to improve the visibility and readability of this
graph taking into account that it is going to continue for many days.

Many thanks.
the URL is: http://buxto-xorovatz.blogspot.com/




--
Oresto





All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com