ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   My chart in Excell will only let me use 5 dates. ? (https://www.excelbanter.com/charts-charting-excel/222711-my-chart-excell-will-only-let-me-use-5-dates.html)

WillB

My chart in Excell will only let me use 5 dates. ?
 
I put in 5 dates on the chart that I am using to track weight loss. When I
add more dates in Excel the chart does not see them. What do I do?

Shane Devenshire

My chart in Excell will only let me use 5 dates. ?
 
Hi,

If you can see the chart and the data at the same time. Click the series on
the chart and notice the highlight in the spreadsheet around the data. The
bottom right corner of each highlight has a small square in the same color as
the highlight. Place your mouse over the square, when you see a 2-headed
arrow drag to expand the range.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"WillB" wrote:

I put in 5 dates on the chart that I am using to track weight loss. When I
add more dates in Excel the chart does not see them. What do I do?



All times are GMT +1. The time now is 07:14 PM.

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