[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1547
  • Last Modified:

Chart in excel: y-axis not granular enough

Hi Guys,

I've been trying to plot a chart in Excel 2007 (on Windows 7).

It's basically some counter vs time-stamp. Now there are holes in the data (e.g. counter is 0 for some period of time, then some values then some 0s). What I want is a complete timeline on x-axis and counter values on y-axis. BY complete I mean if there is a hole in the value I want it visible on chart.

Attached excel contains the original data in col A and B. Col A's timestamps are pretty haywire, it's the raw data. First chart on RHS corresponds to that.

Then I created another set of data out of it, that's in Col D & E. Col D is time incremented by 5 mins (complete timeline without holes in time). Col E is the sum of counter value between D's timestamp and "D's timestamp - 5 mins". Now all I want to do is plot it. That's the second chart.

1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

change the chart type to an XY Scatter chart. Then set the minimum and maximum values of the X axis close to the actual data to avoid the white space between the Y axis and the first data point.

Play around with the settings for major and minor X axis labels. In the attached sample I've set the major value to 0.125, which is 3 hours, so there will be an X axis label every three hours

cheers, teylyn
theKashyapAuthor Commented:
Thank you. Perfect!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now