Edit X-Axis to Show Categories

[JuliusV]

Hi All,

I am trying to figure out how I can change the X-Axis from displaying 0 - 6 to instead show Buckets 1 to Bucket 6. The Buckets 1 to Buckets 6 are the column headings and I want those to be displayed. Note the values driving the length of the bar is the total column which I want to keep. I have inserted text boxes of what I am trying to achieve but need it to be linked to the graph.

Thank you,

Julius

 

[Nebu]

Hi:

Find the attached. Its a cheeky way of achieving this. I created a dummy graph and overlapped the original graph to get the effects you were looking for.

Thanks

 

[JuliusV]

Hi Nebu,

Thank you for your response. I have encountered this type of issue before and was trying to see if there is a way without overlaying a dummy graph? Ideally, I was hoping to be able to easily upload the graph into PPT. In the past, I have manually added in all of the x-axis labels. Though I see how this solution already provides a way to save time.

Thanks,

Julius

 

[Nebu]

Hi:

You can always group the two graphs together to copy it.

Thanks

 

[Dharlome08]

You could always use a custom number format for the axis: "Bucket" #,##0

 

[JuliusV]

Thank you for all the help. It is great to know that you can group objects in excel too.