asked on

Creating Excel 2010 Chart

I have created a workbook with 3 pages. Page 1 list my charts and page two list my weekly disk space usage and the 3 page list the usage per month.

On my charts I have selected 2-D Line w/ markers. My monthly chart on the horizontal axis correctly list out the scheduled dates data will be listed i.e: 6/6/2016, 7/5/2016 etc.. Yet my weekly chart only list three weeks and has huge spaces in-between each date. I am not a Excel guru but how can I correct this to list all of my dates just like the monthly chart did by default.

Edward Pamias

Can you post a sample sheet? Or maybe a screenshot of the graphs?

compdigit44

ASKER

Thank for the reply... Please see if the attached screen shot helps..
ExcelScreenShot.png

ASKER CERTIFIED SOLUTION

Jerry Paladino

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

compdigit44

ASKER

When I right click and select "Format Axis" I tried to change the Unit value as suggested but did not seem to work I may not how selected the correct option though
ExcelScreenShot2.png

Jerry Paladino

I cannot replicate your exact situation and I no longer have access to a copy of Excel 2010 which I believe you are using based on the format of the Axis Option dialog in your last screen print. As a suggestion from your screen print, on the Major Unit item, select the Fixed button, leave the 1 as is and then change Months to Days.

Edward Pamias

If you right click on the weekly graph in 2010, click select data, what do you have on the horizontal axis label?

compdigit44

ASKER

Well I figured out my problem... I simple had to resize my chart so all of the data would show...LOL

Thanks for the help though...

Edward Pamias

Good to hear you got it resolved. :)

@Jerry thanks for the solution, I may use this on issues I have with my graphs.

Jerry Paladino

@compdigit44 - Glad it worked out...

@Edward - No problem... Happy to help...