View Single Post
  #10   Report Post  
Old October 8th 20, 09:50 PM posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2019
Posts: 64
Default X Y Scatter Excel Graph X Axis Customization

"Peter T" wrote in message

... Another way would be to start with a dummy Line series with all zero Y
values (assuming the x-axis cross the Y at 0) with the x-category values
your text cells, then add further Series as Scatter types

To do that add the first ...

Easier than I suggested last time -
- Add a row of zeros just below the 'hook' labels.
- Select all the data including the 'hook' and 'load' labels
- Create a Line style chart with markers
- Change the chart type Combo
- Leave the first dummy series as Line type
- Change the other 'load' series to Scatter type

This time no secondary axes were created, for me

Format the dummy Series Line to not be visible

Quick and easy, except it could have been simply a Line chart!