Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 291
- Office Version
- 365
- Platform
- Windows
Hi All,
I have combo graph in Excel 2013 - the secondary axis is the percentage up or down of sales year on year. As we are mid way thru the year some of the data is 0. I have an If formula that populates a #n/a if the value is 0 - this works on my normal primary axis mapping of sales weekly over the last couple of years. The secondary axis graph is fine, but when I add labels, it also populates the #n/a value on the label, whereas I need it to be blank?
I was also wondering if it is possible to select certain data to appear in the data table below the graph? When I add a data table I get all data elements, whereas I want only the secondary axis data to appear?
Any help - greatly appreciated.
Best - Mark.
I have combo graph in Excel 2013 - the secondary axis is the percentage up or down of sales year on year. As we are mid way thru the year some of the data is 0. I have an If formula that populates a #n/a if the value is 0 - this works on my normal primary axis mapping of sales weekly over the last couple of years. The secondary axis graph is fine, but when I add labels, it also populates the #n/a value on the label, whereas I need it to be blank?
I was also wondering if it is possible to select certain data to appear in the data table below the graph? When I add a data table I get all data elements, whereas I want only the secondary axis data to appear?
Any help - greatly appreciated.
Best - Mark.