Share via

Clustered Column chart with one series on secondary axis

Anonymous
2020-04-10T10:28:41+00:00

Hi,

I would like to have a chart with clustered column design with two series, however, I want to have the second series on a secondary y-axis. Is that even possible? I realize there is this clustered column/line chart type, but I don't want one series to be a line, I want both as columns. When I just go to format data series and select "Secondary Axis" in the section "Series Options", it seems like columns of both series are rendered ontop of each other, i.e. on the same positions, so the second series columns occlude the ones of the first.

Using Excel for Office 365 (Home edition, I guess, how do I figure out? Product Informaton doesn't tell any details anymore.)

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-10T10:40:54+00:00

    Hello rAigner

    I am V. Arya, Independent Advisor, to work with you on this issue. Use these

    https://www.exceldashboardtemplates.com/stop-ex...

    https://peltiertech.com/excel-column-chart-prim...

    Standard Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2020-04-14T11:27:56+00:00

    Hello rAigner

    I am V. Arya, Independent Advisor, to work with you on this issue. Use these

    https://www.exceldashboardtemplates.com/stop-ex...

    https://peltiertech.com/excel-column-chart-prim...

    Standard Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    So, basically the only way to do this is using a workaround, introducing dummy columns, did I get this right?

    0 comments