Setting Chart Y axis to start at no less than 0

**beerbud89** · 05-02-2013, 04:04 PM

Can anyone tell me what line needs to but changed or put into this code so that my last chart with two series will read from 0 up. Some of my data in the range for the series are negative numbers and it makes the chart look ridiculous and I really don't need the negative data.

Please Login or Register  to view this content.

Chart2.jpg

**ExcelTab** · 05-03-2013, 03:49 AM

Hello beerbud89,

Add this to the end of your code :

Please Login or Register  to view this content.

Have fun !

**beerbud89** · 05-03-2013, 09:23 AM

Thanks ExcelTab! That worked great! There are a couple of things I would like to do to tweak my charts a little. I would like the line colors of series 1 in each chart to be blue. I have already figured out how to change the line color of series 2 in the last chart to red. Also, how can I get the third chart a little clearer? It's kind of hard to read. I've attached a jpeg of the charts and what they look like with your addition to my code.

Please Login or Register  to view this content.

Charts.jpg

**beerbud89** · 05-03-2013, 09:58 AM

Is there a way to make the series data start at zero or the first positive number instead of reading the negatives at all? That may be a better option!

**ExcelTab** · 05-03-2013, 10:43 AM

Hello beerbud89,

There is a way, but it is quite tidious (personnaly, i like your graphs the way they are).

Anyway, to change your 3rd graph, and take only positive data, one way is to recreate new array of values (here called XValues2 and Values2) and build a loop similar to the following:

Please Login or Register  to view this content.

In this code, i am assuming that you want to do this for your last column (the one you put in XValRange.offset(0,8)).

Dont forget to do the same thing for your SeriesCollection(1) values.
Then, when building your graph, use the XValues2 and Values2 array to populate them.

Have fun !

**beerbud89** · 05-03-2013, 10:56 AM

It is quite tedious. Especially because of my lack of VBA knowledge. I had help building the code so I am not sure where to place the new array or the lope. I can try to figure it out though!